Create and delete databases in an RDS MariaDB instance by using the console, SQL commands, or API operations.
Background information
Concepts
-
Instance: A virtual database server. You can create and manage multiple databases within an instance.
-
Database: A data collection shared by multiple users, independent of the applications that use it.
-
Character set: A collection of characters, symbols, and their encoding rules used in a database.
Prerequisites
Limits
You cannot modify database names in RDS MariaDB.
Create a database
Use the 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 navigation pane on the left, click Databases.
-
Click Create Database.
-
Set the following parameters:
Parameter
Description
Database (DB) Name
-
2 to 64 characters in length.
-
Must start with a letter and end with a letter or digit.
-
Can contain lowercase letters, digits, underscores (_), and hyphens (-).
-
Must be unique within the instance.
NoteIf a database name contains
-, the-in the folder name of the created database is converted to@002d.Supported Character Set
Select a character set.
Authorized Account
Select accounts that need access to this database. You can skip this and grant permissions later from Modify or reset account permissions.
NoteOnly standard accounts are listed. Privileged accounts have all permissions on all databases and do not require authorization.
Remarks
Optional. Add remarks about the database. Maximum: 256 characters.
-
-
Click Create.
Use SQL commands
-
Run the following command to create a database:
CREATE DATABASE <database name>;
Delete a database
Deleting a database makes it permanently inaccessible. Proceed with caution.
Use the 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 navigation pane on the left, click Databases.
-
Find the database that you want to delete and click Delete in the Actions column.
-
In the confirmation message that appears, click OK.
Use SQL commands
-
Run the following command to delete a database:
DROP DATABASE <database name>;
Related API operations
|
API |
Description |
|
Creates a database. |
|
|
Deletes a database. |