1. Home
  2. MySQL Tutorials
  3. MySQL – Show Databases

MySQL – Show Databases

Use SHOW DATABASES statement to list/show databases in MySQL Database host.

mysql> SHOW DATABASES;

Output:

mysql> SHOW DATABASES;

+--------------------+
| Database                         |
+--------------------+
| information_schema   |
| FOSS                               |
| mysql                              |
| performance_schema |
+--------------------+

4 rows in set (0.02 sec)

Similarly, the mysqlshow command can be used to generate the lists of databases
available on the MySQL server host.

Was this article helpful to you? Yes No

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.