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

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.

Tags
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.