Manage databases (MySQL)

Background information

Logging on to a database lets you manage database objects, import and export data, edit and execute SQL statements, compile and debug PL, process data and structures, analyze execution, and perform database O&M. For more information, see Introduction to Developer Center.

You can manage accounts to configure different database access permissions for each account as needed.

Procedure

1. Log on to the OceanBase Management Console .

2. In the navigation pane on the left, click Instance List.

3. In the Instance List, select the target instance and click the instance name to go to the Cluster Instance Workbench page.

4. On the Cluster Instance Workbench page, click the target tenant in the tenant list to go to the Tenant Workbench page.

5. In the navigation pane on the left, click Database Management. In the upper-right corner of the Database Management page, you can search for a database by name, log on to a database, or create a new database. For more information, see Log on to a database and Create a database (MySQL).

6. In the database list, you can view information such as Database Name, Character Set, Status, Disk Used, and Attached Accounts.

7. Click the edit icon in the Remarks column to add a remark. The remark can be up to 30 characters long.

8. In the Actions column, click Manage Accounts to grant database permissions to the corresponding accounts.

   • Data Definition Language (DDL) permissions: SHOW DATABASES, SHOW VIEW, CREATE, CREATE VIEW, DROP, INDEX, ALTER

   • Data Manipulation Language (DML) permissions: SELECT, DELETE, INSERT, UPDATE

   • Read-only permission: SELECT

   • Read and write permission: ALL

     

     Note

     If you change the permissions for an account in the console, such as from read and write to read-only, the account must reconnect to the database for the new permissions to take effect.

9. In the Actions column, click the More icon to delete the database.