Creating a Database

Scenarios

Constraints

• Databases cannot be created for DB instances that are in the process of being restored.
• You can only manage databases in the primary instance, for example, creating or authorizing users for databases.
• This section applies only to the MySQL DB engine.

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.
4. On the Instances page, click the target DB instance.
5. On the Databases page, click Create Database. In the displayed dialog box, enter a database name and remarks, select a character set, and authorize permissions for users. Then, click OK.
   • The database name consists of 1 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. The total number of hyphens (-) cannot exceed 10.
   • The default character set is utf8. You can click More and select another one.
   • Select unauthorized users and click to authorize permissions or select authorized users and click to revoke permissions.

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

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