All Products
Search
Document Center

AnalyticDB for MySQL:Create a database account

Last Updated:Mar 01, 2024

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

  1. Log on to the AnalyticDB for MySQL console.
  2. In the upper-left corner of the page, select a region.
  3. In the left-side navigation pane, click Clusters.
  4. On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.
  5. In the left-side navigation pane, click Accounts.
  6. On the Accounts tab, click Create Privileged Account.
  7. In the Create Account panel, configure the parameters that are described in the following table.
    ParameterDescription
    Database AccountThe name of the privileged account. Enter a name that meets the on-screen requirements.
    Account TypeFor a Data Warehouse Edition (V3.0) cluster, this parameter is automatically set to Privileged Account.
    New PasswordThe password of the privileged account. Enter a password that meets the on-screen requirements.
    Confirm PasswordEnter the password of the privileged account again.
    DescriptionOptional. The description that is used to identify the account for future management.
  8. 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.