Create a database account

Create a privileged account

1. Log on to the PolarDB console.
2. On the top of the page, select the region where the target cluster is located.
3. Find the target cluster and click the cluster ID to go to the Overview page.
4. In the left-side navigation pane, choose Settings and Management > Accounts.
5. On the page that appears, click Create Account.
6. In the Create Account panel, configure the following parameters.

   Parameter	Description
   Account Name	Specify an account name. The account name must meet the following requirements: It must start with a lowercase letter and end with a letter or a digit. It can contain lowercase letters, digits, and underscores (_). It must be 2 to 16 characters in length. It cannot be a system reserved username, such as root or admin.
   Account Type	Specify the type of the account. Select Privileged Account. Note If you have already created a privileged account, you cannot select Privileged Account. You can create only one privileged account for each cluster.
   Password	Enter an account password. The password must meet the following requirements: It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. It must be 8 to 32 characters in length. It can contain the following special characters: !@#$%^&*()_+-=
   Confirm Password	Enter the account password again.
   Description	Enter the information about the account to facilitate subsequent account management. The description must meet the following requirements: It cannot start with http:// or https://. It must be 2 to 256 characters in length.

7. Click OK.

Create a standard account

1. Log on to the PolarDB console.
2. On the top of the page, select the region where the target cluster is located.
3. Find the target cluster and click the cluster ID to go to the Overview page.
4. In the left-side navigation pane, choose Settings and Management > Accounts.
5. On the page that appears, click Create Account.
6. In the Create Account panel, configure the following parameters.

   Parameter	Description
   Account Name	Specify an account name. The account name must meet the following requirements: It must start with a lowercase letter and end with a letter or a digit. It can contain lowercase letters, digits, and underscores (_). It must be 2 to 16 characters in length. It cannot be a system reserved username, such as root or admin.
   Account Type	Specify the type of the account. Select Standard Account.
   Databases	Select the authorized databases for the account. You can leave this parameter empty. You can grant the account the database permissions after the account is created. Select one or more databases from the Databases Not Assigned list and click the icon. Then, the selected databases are added to the Assigned Databases list. In the Assigned Databases list, specify the permissions on the selected databases. To specify the permissions, select one of the following options: Read&Write, ReadOnly, DMLOnly, DDLOnly, and ReadOnly&Index. Note If you need to customize the permissions or grant the account specific table permissions, click Customize Permissions below the Databases Not Assigned list. On the page that appears, you can use the permission management feature of Database Management Service (DMS) to manage the account permissions. For more information, see Manage user permissions on MySQL databases.
   Password	Enter an account password. The password must meet the following requirements: It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. It must be 8 to 32 characters in length. It can contain the following special characters: !@#$%^&*()_+-=
   Confirm Password	Enter the account password again.
   Description	Enter the information about the account to facilitate subsequent account management. The description must meet the following requirements: It cannot start with http:// or https://. It must be 2 to 256 characters in length.

7. Click OK.

Reset the permissions of a privileged account

If the permissions of a privileged account are accidentally revoked or encounter other exceptions, you can reset the permissions to restore the privileged account to the initial state. To reset the permissions of the account, perform the following steps:

1. Log on to the PolarDB console.
2. On the top of the page, select the region where the target cluster is located.
3. Find the target cluster and click the cluster ID to go to the Overview page.
4. In the left-side navigation pane, choose Settings and Management > Accounts.
5. On the page that appears, find the privileged account that you want to manage. In the Actions column for the privileged account, click Reset Permissions
6. In the dialog box that appears, enter the password of the privileged account. Then, click OK to reset the permissions of the account.

What to do next

View or apply for an endpoint

Related API operations