Granting Database Permissions

Scenarios

You can grant permissions to database users you have created to use specific databases or revoke permissions from specific database users.

Constraints

• Permissions cannot be granted to database users for a DB instance that is in the process of being restored.

• Databases and accounts created using other methods than the RDS console and APIs are also displayed on the RDS console. If the names of the created databases or accounts do not meet the database naming rule or account naming rule, for example, the names containing Chinese characters or unsupported special characters, the databases or accounts cannot be managed on the RDS console or through APIs.
• If the name of any database or account on the source database does not meet the database naming rule or account naming rule, the database or account cannot be managed on the RDS console or through APIs after being migrated to the destination RDS for MySQL instance.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the DB instance name.
5. In the navigation pane on the left, choose Databases. On the displayed page, locate the target database and click Authorize in the Operation column.
6. In the displayed dialog box, select unauthorized users and click to authorize them or select authorized users and click to revoke permissions.

   If no users are available, you can create one by referring to Creating a Database Account.

   Figure 1 Granting database permissions
   

7. Click OK.