This topic describes how to create a database on an RDS for MariaDB instance.

Concepts

  • Instance: a virtual database server, on which you can create and manage multiple databases.
  • Database: an interrelated set of data that is stored together and can be shared by multiple users. A database provides the lowest level of redundancy. It serves as a data warehouse independent of the applications.
  • Character set: a collection of characters, such as letters and special characters, and encoding rules used in a database.

Prerequisites

An ApsaraDB RDS for MariaDB instance is created. For more information, see Creates an ApsaraDB RDS for MariaDB instance.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Databases.
  5. Click Create Database.
  6. Configure the following parameters.
    Parameter Description
    Database Name
    • The database name must be 2 to 64 characters in length.
    • The database name must start with a lowercase letter and end with a lowercase letter or digit.
    • The database name can contain lowercase letters, digits, underscores (_), and hyphens (-).
    Supported Character Set Select utf8, gbk, latin1, or utf8mb4.
    Authorized Account Select one or more accounts that require access to the database. You can leave this parameter empty and configure account permissions after you create the database.
    Note Only standard accounts are available in the drop-down list. The privileged account has all permissions on all databases without authorization.
    Account Type Select the permissions that you want to grant to the selected accounts. You can select Read/Write, Read-only, DDL Only, or DML Only.
    Description Optional. Enter information that helps identify the database. The description can be up to 256 characters in length.
  7. Click Create.

What to do next

Connect to an RDS for MariaDB instance.

Related operations

Operation Description
CreateDatabase Creates a database.