MySQL Show Info About Database
The SHOW DATABASE statement is used to display info about MySQL databases. An error occurs if the database not exists.
SHOW DATABASE Example
The following SQL statement Shows the existing 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.