This topic describes how to create a database account for an AnalyticDB for MySQL cluster and explains the differences between privileged accounts and standard accounts.
Account types
AnalyticDB for MySQL supports two types of database accounts: privileged accounts and standard accounts. For more information about the differences between privileged accounts and standard accounts, see Account types.
Create a privileged account
- Log on to the AnalyticDB for MySQL console.
- In the upper-left corner of the page, select a region.
- In the left-side navigation pane, click Clusters.
- On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.
- In the left-side navigation pane, click Accounts.
- On the Accounts tab, click Create Privileged Account.
- 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 For a Data Warehouse Edition (V3.0) cluster, this parameter is automatically set to 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. - Click OK.
Create and grant permissions to a standard account
The standard accounts that are created by using SQL statements for Data Warehouse Edition (V3.0) clusters are not displayed in the console.
- For more information about how to create a database account, see CREATE USER.
- For more information about how to grant permissions to a database account, see GRANT.
- For more information about how to revoke permissions from a database account, see REVOKE.
- For more information about how to change the name of a database account, see RENAME USER.
- For more information about how to delete a database account, see DROP USER.