Create database

Last Updated: Dec 11, 2017

You 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, see 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.

Procedure

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

  2. Select Database Management in the left-side navigation pane, and click Create database, as shown in the following figure.

    Create a Database

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

    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.

Thank you! We've received your feedback.