This topic describes how to create a database for an ApsaraDB RDS for MySQL instance.

Prerequisites

An ApsaraDB RDS for MySQL instance is created. For more information, see Create an ApsaraDB RDS for MySQL instance..

Terms

  • instance: a virtualized database server. You can create and manage multiple databases on an RDS instance.
  • database: a set of data that is stored in an organized manner and can be shared by a number of users. A database provides the minimal redundancy and is independent of applications. In simple words, a database is a data warehouse that is used to store data.
  • character set: a collection of letters, special characters, and encoding rules that are used in a database.

Maximum number of databases and maximum number of tables

Account typeMaximum number of databasesMaximum number of tables
Privileged accountIn ApsaraDB RDS for MySQL, no limits are imposed on the number of databases that can be created on an RDS instance. Limits may be imposed on the number of directories in underlying file systems. Less than 200,000
Standard accountLess than 200,000

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, click Databases.
  3. On the page that appears, click Create Database.
  4. Configure the following parameters.
    ParameterDescription
    Database Name
    • The name of the database. The name must be 2 to 64 characters in length.
    • The name must start with a lowercase letter and end with a lowercase letter or digit.
    • The name can contain lowercase letters, digits, underscores (_), and hyphens (-).
    • The name must be unique within the RDS instance.
    Note If the database name contains a hyphen (-), the system parses the hyphen (-) as @002d in the name of the folder in which the database resides.
    Supported Character SetThe character set of the database. Select utf8, gbk, latin1, or utf8mb4.
    Authorized AccountThe authorized account of the database. You can leave this parameter empty. In this case, you can specify the authorized account of the database after the database is created. For more information, see Modify the permissions of a standard account on an ApsaraDB RDS for MySQL instance.
    Note The Authorized Account drop-down list displays only the standard accounts that are created on your RDS instance. The privileged account has all permissions on all databases and does not require authorization.
    DescriptionThe description of the database. This parameter is optional. You can configure this parameter to help you manage the database. The description can be up to 256 characters in length.
  5. Click OK.

What to do next

Connect to the RDS instance. For more information, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.

Related operations

OperationDescription
CreateDatabaseCreates a database.