You can modify the permissions of a standard account created on an ApsaraDB RDS for MySQL instance. The permissions of a privileged account can only be reset to the default settings.

Modify the permissions of a standard account

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Accounts.
  5. Find the account for which you want to modify the permissions and click Edit Permissions in the Actions column.
  6. On the Accounts page, modify the permissions of the standard account.
    • Modify the authorization on databases: Select one or more databases and click Add or Remove.
    • Specify the permissions on authorized databases: In the Authorized Databases section, specify the Read/Write, Read-only, or Owner permissions on a single authorized database. Alternatively, specify permissions on all of the authorized databases simultaneously by clicking the button in the upper-right corner. The button shows Set All to Read/Write, Set All to Read-only, and Set All to Owner as you click it.