PolarDB:Manage databases

Create a database

1. Log on to the PolarDB console. In the left-side navigation pane, click Clusters. Select your cluster's Region, and then click the cluster ID to open the details page.

2. In the left-side navigation pane, go to Settings and Management > Databases.

3. Click Create Database.

4. In the Create Database panel, configure the following parameters and click OK.

   Parameter	Description
   Database Name	Must start with a letter and end with a letter or a digit. Can contain only lowercase letters, digits, underscores (_), and hyphens (-). Must not exceed 64 characters. The name must be unique within the instance. Note Do not use reserved keywords, such as test or mysql, as the database name.
   Supported Character Set	Select a character set, such as utf8mb4, utf8, gbk, and latin1.
   Collate	The collation for the database. Note To view the value range for this parameter, in the PolarDB Console, navigate to target cluster > Settings and Management> Databases tab and click Create Database.
   Authorized Account	Select an account to access the database. You can leave this field blank and authorize an account after the database is created. Note Only standard accounts are displayed here. Privileged accounts have full permissions for all databases and do not require authorization.
   Account Permissions	Select the permissions to grant to the account. Valid values are Read/Write, Read-only, DML Only, DDL Only, and Read-only + Index.
   Description	Enter a description for the database. The description must meet the following requirements: Cannot start with http:// or https://. Must be 2 to 256 characters long.

Delete a database

1. Log on to the PolarDB console. In the left-side navigation pane, click Clusters. Select your cluster's Region, and then click the cluster ID to open the details page.

2. In the left-side navigation pane, go to Settings and Management > Databases.

3. Find the database and click Delete in the Actions column.

4. In the confirmation dialog, click OK.

FAQ

SHOW DATABASES;

Related APIs