View databases

This topic describes how to view databases in MySQL mode by using an SQL statement.

Procedure

1. Log on to the MySQL tenant of the cluster.

2. Use the SHOW DATABASES statement to view the information about databases under the MySQL tenant.

   Example:

   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.