This topic describes how to modify the permissions of a standard account on an ApsaraDB RDS for MySQL instance. The permissions of a privileged account can only be reset to the default settings but cannot be modified.

Note You can use the Account Authorization and Management feature of Alibaba Cloud Data Management (DMS) to define permission combinations. You can also use this feature to manage the permissions on specific tables. For more information, see Manage user permissions on MySQL databases.

Procedure

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Accounts.
  3. Find the standard account whose permissions you want to modify, and click Edit Permissions in the Actions column.
  4. In the Modify Account Permissions pane, modify the permissions of the standard account.
    • If you want to add or remove an authorized database, select the database and click the > or < icon.
    • If you want to modify the permissions on an authorized database, select the database and then select the Read/Write (DDL + DML), Read-only, DDL Only, or DML Only permissions in the Authorized Databases section.
      Note You can use SQL statements to modify permissions at higher levels of granularity. For more information, see Account permissions.
  5. In the message that appears, click OK.