Account
Categories

MySQL SHOW DATABASES command


When you want to see all available databases in the system, then you use the 'SHOW DATABASES' command.

It displays the list of all databases stored in the system.

Syntax:

SHOW DATABASES;

Command:

SHOW DATABASES;

Output:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| SchoolDB           |
+--------------------+