MySQL Show Databases

In this tutorial, We are cover how to show  database in MySQL using command line.

First Login to MySQL database with MySQL Username and Password.

$ mysql -u username -p

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.