PolarDB:Manage databases

Prerequisites

Before you begin, ensure that you have:

• A PolarDB cluster

• Access to the PolarDB console

Create a database

1. Log on to the PolarDB console. In the left navigation pane, click Clusters. Select the region of the cluster, then click the cluster ID.

2. In the left navigation pane, click 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 (-). Maximum 64 characters. Must be unique within the cluster. Do not use reserved keywords such as test or mysql.
   Supported character set	Character set for the database: utf8mb4, utf8, gbk, or latin1.
   Collate	Collation for the database. To view valid values, open the Create Database panel in the console at Configuration And Management > Database Management.
   Authorized account	Accounts to grant access to this database. Leave blank to configure access after the database is created. Only standard accounts appear here — privileged accounts have full access to all databases and do not require authorization.
   Account permissions	Permissions for the authorized account: Read/Write, Read-only, DML Only, DDL Only, or Read-only + Index.
   Description	An optional description to help with future management. Cannot start with http:// or https://. Must be 2–256 characters.

Delete a database

1. Log on to the PolarDB console. In the left navigation pane, click Clusters. Select the region of the cluster, then click the cluster ID.

2. In the left navigation pane, click Settings and Management > Databases.

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

4. In the dialog box, click OK.

FAQ

SHOW DATABASES;

API reference