This topic describes how to create a database on an ApsaraDB RDS for MariaDB instance.
Prerequisites
An RDS instance is created. For more information, see Create an ApsaraDB RDS for MariaDB instance.
Create a database
Use the ApsaraDB RDS console
- 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.
In the left-side navigation pane of the page that appears, click Databases.
On the page that appears, click Create Database.
In the panel that appears, configure the parameters that are described in the following table.
Parameter
Description
Database Name
The name of the database. It must be 2 to 64 characters in length.
It must start with a letter and end with a letter or digit.
It can contain lowercase letters, digits, underscores (_), and hyphens (-).
The name must be unique within the RDS instance.
NoteIf the database name contains a hyphen (
-
), the system parses the hyphen (-
) in the name of the folder in which the database resides as@002d
.Supported Character Set
The character set of the database. Select a character set based on your business requirements.
Authorized Account
The authorized account of the database. You can leave this parameter empty. If you leave this parameter empty, 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.
NoteThe Authorized Account drop-down list displays only the standard accounts that are created on your instance. The privileged account has all permissions on all databases and does not require authorization.
Description
The 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.
Then, click OK.
Use SQL statements
Execute the following statement to create a database:
CREATE DATABASE <database name>;
What to do next
Related operations
Operation | Description |
Creates a database. | |
Deletes a database. |