Note: This document is applicable only to MySQL 5.5 and 5.6. For more information on how to create a database and an account for MySQL 5.7, see Create a database and an account for MySQL 5.7.
Before using RDS, you must create databases and accounts in the RDS instance. For MySQL 5.5 and 5.6, this document provides detailed procedure to create and manage the databases and accounts directly by using the RDS console. .
Databases under a single instance share all the resources of this instance. Each MySQL 5.5 or 5.6 instance supports up to 500 databases and 500 accounts.
To migrate the local database to RDS, you must create the same database and account as those of the local database.
When assigning account permissions for each database, follow the minimum permissions’ principle and service roles to create accounts and rationally assign Read-only and Read/Write permissions. When necessary, you can split accounts and databases into smaller units so that each account can only access data for its own services. If the account does not need to write data to a database, assign Read-only permission.
For database security, set strong passwords for the accounts and change the passwords regularly.
Log on to the
Select the region where the target instance is located.
Click the ID of the instance to visit the Basic Information page.
Select Account Management in the left-side navigation pane to visit the Account Management page.
Click Create Account, as shown in the following figure.
To create an account, enter the relevant details in the required fields, as shown in the following figure.
Database Account: refers to the account name. It can have 2 to 16 characters including lower-case letters, digits, or underscores (_). It must begin with a letter and end with a letter or a digit.
Authorized Database: refers to the database that this account is authorized to access. If there is no database, you do not need set this field. Follow the steps to authorize an account to the multiple databases:
In Unauthorized Database box, select the target database.
Click Authorize to add the selected database to the Authorized Database box.
You can authorize the Read-only or Read/Write permission to the account for each authorized database. If you want to authorize the same permissions to the account for all the authorized databases, click Set All Read/Write or Set All Read-only, as shown in the following figure.
Password: refers to the password corresponding to this account. It can have 8 to 32 characters including at least three of the following:
Special characters ( !@#$%^&*()_-+=)
Re-enter Password: re-enter the password to make sure the password is entered correctly.
Note: you can add the additional information relevant to this account for the convenience of follow-up account management. A maximum of 256 English characters can be entered (one Chinese character equals to three English characters).
Click OK, and an account is created.
Select Database Management in the left-side navigation pane to visit the Database Management page.
Click Create Database, as shown in the following figure.
Enter the information of the database, as shown in the following figure.
Database (DB) Name: can have 2 to 64 characters including the lowercase letters, digits, underscores (_), or hyphens (-). It must begin with a letter and end with a letter or a digit.
Supported Character Set: refers to the supported character set of the database. You can select utf8, gbk, latin1, or utf8mb4.
Authorized Account: you can select an account authorized to access this database. Set this field only if the account is created.
Account Type: this option is visible after Authorized Account is set. You can authorize Read/Write or Read-only permission to the authorized account.
Remarks: Enter the additional information relevant to this database, to facilitate the database management for further follow-up. A maximum of 256 English characters can be entered (one Chinese character equals to three English characters).