CREATE DATABASE db_name
CREATE DATABASE creates a database with the given name. Rules for
allowable database names are given in 7.1.5 Database, table, index, column and alias names. An error occurs if
the database already exists.
Databases in MySQL are implemented as directories containing files
that correspond to tables in the database. Since there are no tables in a
database when it is initially created, the
CREATE DATABASE statement
only creates a directory under the MySQL data directory.
You can also create databases with
12.1 Overview of the different MySQL programs.