AnalyticDB:Create a database account

Account types

AnalyticDB for MySQL supports two types of database accounts: privileged accounts and standard accounts.

Create a privileged account

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, click an edition tab. Find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, click Accounts.

3. On the Database Accounts tab, click Create Account.

4. In the Create Account panel, configure the parameters that are described in the following table.

   Parameter	Description
   Database Account	The name of the privileged account. Enter a name that meets the on-screen requirements.
   Account Type	Specify the type of the account. Select Privileged Account.
   New Password	The password of the privileged account. Enter a password that meets the on-screen requirements.
   Confirm Password	Enter the password of the privileged account again.
   Description	Optional. The description that is used to identify the account for future management.

5. Click OK.

Create and grant permissions to a standard account

Console operations

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, click an edition tab. Find the cluster that you want to manage and click the cluster ID.

2. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, click an edition tab. Find the cluster that you want to manage and click the cluster ID.

3. On the Database Accounts tab, click Create Account.

4. In the Create Account panel, configure the parameters that are described in the following table.

   Parameter	Description
   Database Account	The name of the standard account. Enter a name that meets the on-screen requirements.
   Account Type	The type of the account. Select Standard Account. Note If you want to use a Resource Access Management (RAM) user to perform SQL development in the AnalyticDB for MySQL console for Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters, you must create a standard account and associate the standard account with the RAM user.
   New Password	The password of the standard account. Enter a password that meets the on-screen requirements.
   Confirm Password	Enter the password of the standard account again.
   Description	Optional. The description that is used to identify the account for future management.

5. Click OK.

6. Find the created account and click Permissions in the Actions column to grant permissions to the account.

SQL syntax

• CREATE USER

• GRANT

• REVOKE

• RENAME USER

• DROP USER