The SHOW DATABASE statement is used to display info about MySQL databases. An error occurs if the database not exists.
Syntax
SHOW DATABASES;
SHOW DATABASE Example
The following SQL statement Shows the existing databases:
Example
SHOW DATABASES;
You can use MySQL Command Line Client to show MySQL databases. It will look like this:
Note: In order to create database, you must have admin privilege. All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.