All Products
Search
Document Center

AnalyticDB:Create a database account

Last Updated:Jul 04, 2024

This topic describes how to create a database account for an AnalyticDB for MySQL Data Lakehouse Edition 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 information about the differences between privileged accounts and standard accounts, see the "Account types" section of the Create a database account topic in User Guide.

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 Data Lakehouse 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 User 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 Data Lakehouse 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 User 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.

    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

  • For information about how to create a database account, see CREATE USER.

  • For information about how to grant permissions to a database account, see GRANT.

  • For information about how to revoke permissions from a database account, see REVOKE.

  • For information about how to change the name of a database account, see RENAME USER.

  • For information about how to delete a database account, see DROP USER.