View the currently connected database

This topic describes how to view the currently connected MySQL database in OceanBase Developer Center (ODC) or by using an SQL statement.

View the currently connected database in ODC

Prerequisites

ODC has connected to the database.

Procedure

1. Log on to the ODC console.

2. On the Connections page, select the connected database and click Open.

3. Hover over the connection name on the menu bar at the top of the page.

Expected result

The database username is displayed.

Note

In the preceding figure, information_schema is the currently connected database.

View the currently connected database by using an SQL statement

SQL statement

show databases;

Examples

1. View all databases.

   obclient> show databases;
   +--------------------+
   | Database           |
   +--------------------+
   | oceanbase          |
   | information_schema |
   | mysql              |
   | test               |
   | test2              |
   | rainoon            |
   +--------------------+
   6 rows in set
   

2. Enter the test database.

   obclient> use ny;
   Database changed
   

3. View the currently connected database.

   obclient> show processlist;
   +------------+------+----------------------+------+---------+------+--------+------------------+
   | Id         | User | Host                 | db   | Command | Time | State  | Info             |
   +------------+------+----------------------+------+---------+------+--------+------------------+
   | 3221601356 | root | 47.100.XX.XX:22716 | ny   | Query   |    0 | ACTIVE | show processlist |
   +------------+------+----------------------+------+---------+------+--------+------------------+
   1 row in set
   

   Note

   In the preceding sample code, ny in the db column indicates the currently connected database.