Change a MyBase MySQL database account - ApsaraDB for MyBase

ApsaraDB MyBase for MySQL lets you manage existing database accounts from the console. You can reset an account's password, update its permissions, or delete it.

Prerequisites

Before you begin, ensure that you have:

An ApsaraDB MyBase for MySQL instance with at least one database account created
Access to the ApsaraDB MyBase console

Go to the Accounts page

All account management operations start from the Accounts page. Complete these steps once, then proceed to the specific operation you want to perform.

Log on to the ApsaraDB MyBase console.
In the upper-left corner, select a region.
In the left-side navigation pane, choose Instances > MySQL.
Find the instance you want to manage and click Details in the Actions column.
In the left-side navigation pane, click Accounts.

Reset the password of an account

Go to the Accounts page.
Find the account whose password you want to reset and click Reset Password in the Actions column.
Enter a new password, confirm the password, and click OK.

The password must meet the following requirements:

Requirement	Details
Length	8–32 characters
Character types	At least three of: uppercase letters, lowercase letters, digits, special characters
Allowed special characters	`! @ # $ % ^ & * ( ) _ + - =`

Delete an account

Go to the Accounts page.
Find the account you want to delete and click Delete in the Actions column.
In the confirmation dialog box, click OK.

Edit permissions of a standard account

Standard accounts support database-level permissions. You can grant or revoke access to individual databases and set the permission level for each one.

Go to the Accounts page.
Find the standard account whose permissions you want to edit and click Edit Permissions in the Actions column.
In the Edit Account Permissions panel, modify the account's database access:
- To add a database, select it in the left list and click >.
- To remove a database, select it in the Authorized Databases section and click <.
- To change the permission level on an authorized database, select the database in Authorized Databases and choose Read/Write (DML), Read-only, or Owner.
Click OK.

Reset permissions of a privileged account

Go to the Accounts page.
Find the privileged account whose permissions you want to reset and click Reset Permissions in the Actions column.
In the Reset Permissions dialog box, enter a new password, confirm the password, and click OK.