Manage databases (MySQL compatible mode)

This topic describes how to manage databases in a tenant of the MySQL compatible mode. For example, you can log in to a database, create a database, and manage accounts.

Procedure

1. Log in to the OceanBase Cloud console. In the left-side navigation pane, click Instances.

2. On the instance list page, click the name of the target cluster instance to go to the Overview page of the instance.

3. In the left-side navigation pane, click Tenants.

4. On the Tenants page, click the name of the target tenant in the Tenants list to go to the Overview page of the tenant.

5. In the left-side navigation pane, click Databases.

6. Click Create Database to create a database. For more information, see Create a database (MySQL compatible mode).

7. In the databases list, check the following parameters to obtain information about each database: Database Name, Character Set, Status, and Account.

8. Click Manage Account for a database in the Actions column to grant database privileges to different accounts as needed.

   • If you select Only DDL, the following privileges are granted: SHOW DATABASES, SHOW VIEW, CREATE, CREATE VIEW, DROP, INDEX, and ALTER.

   • If you select Only DML, the following privileges are granted: SELECT, DELETE, INSERT, and UPDATE.

   • If you select Read-only, the SELECT privilege is granted.

   • If you select Read/Write, all preceding privileges are granted.