Create a new user account.

Syntax

CREATE USER user[@host]
  [IDENTIFIED BY 'password']
  WITH [DEFAULT RESOURCE POOL = poolname]
  [REQUIRE {SSL | NONE}]

Arguments

• user: The name of the user. Maximum length of 32 characters.
• host: The host that the user can connect from. For example, specifying localhost means the user account can be used only when connecting from the local host. If no host is explicitly specified, the % wildcard will be used, which allows the user to connect from any host.
• password: An optional database connection password.
• poolname: The default resource pool for the user.
• REQUIRE: SSL option ensures that the user connects via SSL. NONE specifies that SSL will not be required for the connection.

Remarks

The CREATE USER command must be run by a user with administrative privileges on the database. Also, the new user does not have any privileges granted by default. Use GRANT to specify privileges for the new user.

Examples

The following example demonstrates how to add a new user and grant it the SELECT privilege on all tables in the mydb database:

CREATE USER joe;
GRANT SELECT ON mydb.* TO 'joe'@'%';

For an example of creating a user with a default resource pool, see setting resource limits.

Was this Article Helpful?

Thanks For Your Feedback!