Manage databases

You can view the databases under a tenant, and create, delete, and modify a database under a tenant.

Prerequisites

• The tenant is a MySQL tenant and a primary tenant.

• You have tenant modification permissions.

• The root password of the tenant exists in the password box of the current user.

Procedure

1. Log on to the OceanBase Cloud Platform (OCP) console. In the left-side navigation pane, click Tenants to go to the Tenants page.

2. In the Tenants section, click the name of the MySQL tenant.

3. In the left-navigation pane, click Database Management to go to the Database Management page.

   • View database information

     In the database list, you can view the following database parameters: Database Name, Character Set, Collation, Zone Priority, Disk Usage, Created At, Read-only, and JDBC Connection String.

   Note

   If the OceanBase Database version is earlier than V2.2.1, you cannot view the creation time.

   

   • Create a database

     To create a database, click Create Database in the upper-right corner. In the Create Database panel, configure the Database Name, Character Set, and Collation parameters and specify whether the database is read-only. Then, click Submit.

   Note

   • The database automatically inherits the zone priorities of the tenant. For information about how to modify zone priorities, see Modify zone priorities.
   • If the zone priorities of the database and tenant are inconsistent, you can click Change the primary zone setting to keep it consistent with that of the tenant to modify the zone priorities of the database.

   

   • Modify database information

     You can click Edit in the Actions column of a database to modify the character set, collation, or read-only attribute of the database.

   Note

   • The database automatically inherits the zone priorities of the tenant. For information about how to modify zone priorities, see Modify zone priorities.
   • If the zone priorities of the database and tenant are inconsistent, you can click Change the primary zone setting to keep it consistent with that of the tenant to modify the zone priorities of the database.

   

   • Delete a database

     To delete a database, click Delete in the Actions column of the database. In the dialog box that appears, enter delete to confirm your operation.

   Notice

   After a database is deleted, the data cannot be recovered. Proceed with caution.