View databases

This topic describes the statements and methods for viewing databases in MySQL-compatible mode.

Procedure

1. Log in to a MySQL-compatible tenant of the cluster.

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

   Example:

   obclient> SHOW DATABASES;
   

   The result is as follows:

   +--------------------+
   | Database           |
   +--------------------+
   | oceanbase          |
   | information_schema |
   | mysql              |
   | test               |
   +--------------------+
   3 rows in set
   

   • information_schema is a built-in database in MySQL that provides access to database metadata.

   • oceanbase stores the system tables of OceanBase Database.

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

   • test is a custom database created by the user.