Database

SHOW DATABASES MySQL Command

SHOW DATABASES MySQL Command

This command is used to display a list of all databases in the MySQL
server instance.

Syntax

The general syntax of the command is as follows:

SHOW DATABASES;

Command Output

This command will return a list of all databases available
in the MySQL server instance.

mysql> SHOW DATABASES;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+——————–+
6 rows in set (0.14 sec)

MySQL SHOW DATABASES Command

Video Tutorial

 

MySQL Tutorials

MySQL Tutorials on this website: