All Products
Search
Document Center

PolarDB:Database management

更新時間:Sep 07, 2024

You can create and manage all PolarDB databases in the console.

Create a database

    Log on to the PolarDB console.

  1. In the upper-left corner, select the region in which the cluster is deployed.

  2. Find the cluster and click its ID.

  3. In the left-side navigation pane, choose Settings and Management > Databases.

  4. Click Create Database.

  5. In the Create Database panel, configure the following parameters.

    Parameter

    Description

    Database Name

    • The name must start with a letter and end with a letter or a digit.

    • The name can contain lowercase letters, digits, underscores (_), and hyphens (-).

    • The name can contain up to 64 characters in length.

    • The name must be unique in your PolarDB instance.

    Note

    Do not use reserved words as database names, such as test or mysql.

    Supported Character Set

    Select the character set supported by the database, such as utf8mb4, utf8, gbk, latin1, etc.

    Collate

    Set the character set collation of databases.

    Note

    To view the valid values for this parameter, perform the following steps: Log on to the PolarDB console and click the ID of a cluster. In the left-side navigation pane, choose Settings and Management > Databases. Then, click Create Database.

    Authorized Account

    Select the account that you want to authorize to access this database. You can leave this parameter empty and bind an account after the database is created.

    Note

    Only standard accounts are available in the drop-down list. Privileged accounts have all the permissions on all databases. You do not need to authorize the privileged accounts to access the database.

    Account Permissions

    Select the permission that you want to grant to the selected account. Valid values: Read/Write, Read-only, DML Only, DDL Only, or Read-only + Index.

    Description

    Enter a description for the database. The description helps facilitate subsequent database management. The description must meet the following requirements:

    • It cannot start with http:// or https://.

    • It must be 2 to 256 characters in length.

  6. Click OK.

Delete a database

    Log on to the PolarDB console.

  1. In the upper-left corner, select the region in which the cluster is deployed.

  2. Find the cluster and click its ID.

  3. In the left-side navigation pane, choose Settings and Management > Databases.

  4. Find the database that you want to delete and click Delete in the Actions column.

  5. In the dialog box that appears, click OK.

Related API operations

API

Description

CreateDatabase

Creates a database.

DescribeDatabases

Queries the database list.

ModifyDBDescription

Modifies the description of a database.

DeleteDatabase

Deletes a database.