View databases

This topic describes how to view databases in MySQL mode.

View databases by using an SQL statement

Log on to the current tenant and use the SHOW DATABASES statement to view databases.

For example, you can log on to the sys tenant as the root user and view databases.

obclient> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| oceanbase          |
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set

• information_schema: allows you to access the database metadata. This is a built-in database in MySQL.

• oceanbase: stores the system tables of OceanBase Database.

• mysql: stores the database users, privilege settings, and keywords.

• test: a custom database created by the current user.

View databases in OCP

You can also view tenant databases in MySQL mode in OceanBase Cloud Platform (OCP).

1. Log on to the OCP console.

2. In the left-side navigation pane, click Tenants to go to the Tenants page.

3. In the tenant list, find the required tenant and click the tenant name. The Overview page appears.

4. In the left-side navigation pane, click Database Management. The Database Management page appears.

5. In the database list, view the information about each database under the current tenant based on the following parameters: Database Name, Character Set, Collation, Zone Priority, Disk Usage, Created On, Read-only, and JDBC Connection String.