Create a database

Last Updated: May 11, 2017

Users can create databases using the RDS Console. Database names are unique within an instance, but can be duplicate across instances.

If you use SQL Server 2012, refer to Creating a database and an account (SQL Server 2012) to create a database using a client.

Background information

Databases under a single instance share all the resources of this instance.

  • MySQL instances support the creation of up to 500 databases.

  • SQL Server 2008 R2 instances support the creation of up to 50 databases.

  • PostgreSQL and PPAS version instances have no limit on the number of databases.

Operation procedure

  1. Log on to the RDS Console and select the target instance.

  2. Select Database Management in the menu, and click Create database, as shown in the figure below.

    Create a Database

  3. Enter the information of the database you want to create, and click OK, as shown in the figure below.

    Database Information

    • Database (DB) name: Contains 2 to 64 characters which consist of lowercase letters, digits, underscores, or hyphens. It must begin with a letter and end with a letter or digit, e.g., dbname4example.

    • Support character set: utf8, gbk, latin1 and utf8mb4.

    • Authorized account: Select an account authorized by this database. This field can be blank if no account has been created.

    • Account type: This option is visible after Authorized Account is selected. Set the permission authorized by this database to Authorized Account, which can be set to Read/Write or Read only.

    • Remarks: This field can be used to store additional information relevant to the database to facilitate management. A maximum of 256 characters can be entered (1 Chinese character is considered 3).

Thank you! We've received your feedback.