Updated on 2025-11-11 GMT+08:00

Creating a Database

Scenarios

After an RDS instance is created, you can create databases on it.

Constraints

  • Databases cannot be created for DB instances that are in the process of being restored.
  • AUTO_PK_ROW_ID is a reserved column name for RDS for MySQL instances. You cannot create it.
  • You can only manage databases in the primary instance, for example, creating or authorizing users for databases.
  1. Log in to the management console.
  2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  3. On the Instances page, click the target instance name to go to the Overview page.
  4. In the navigation pane on the left, choose Databases and Accounts.
  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 (-), underscores (_), and dollar signs ($) are allowed. RDS for MySQL 8.0 does not support dollar signs ($). The total number of hyphens (-) and dollar signs ($) 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.

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

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