The CREATE DATABASE statement is creates a database with the given name. To use this statement, you need the CREATE privilege for the database. An error occurs if the database already exists and you did not specify IF NOT EXISTS.
Syntax
CREATE DATABASE databasename;
You can use MySQL Command Line Client to create database. It will look like this:
You can use MySQL Command Line Client to show databases. It will look like this: