Creating a Database

Scenarios

After a DB instance is created, you can create databases on it.

Constraints

Databases cannot be created for DB instances that are being restored.

Creating a Database through RDS

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
4. On the Instance Management page, click the target DB instance.
5. On the Databases page, click Create Database. In the displayed dialog box, enter a database name, select a character set, and authorize permissions for users. Then, click OK.
   Figure 1 Creating a database
   
   • The database name contains 1 to 64 characters. Only letters, digits, hyphens (-), underscores (_), and dollar signs ($) are allowed. The total number of hyphens (-) and dollar signs ($) cannot exceed 10. MySQL 8.0 does not support dollar signs ($).
   • The default character set is utf8. You can click Show and select another one.
   • Select unauthorized users and click to authorize permissions (mandatory) or select authorized users and click to revoke permissions.

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

6. After the database is created, you can manage it on the Databases page of the selected DB instance.
   

   The AUTO_PK_ROW_ID column name is a reserved column name for the RDS for MySQL database and cannot be created by users.