CREATE DATABASE in MySQL To create a MySQL database, open the MySQL Command Line Client. The MySQL Command Line Client will appear with a mysql> prompt. Write the already set password, and you are ready to create a MySQL database.
Syntax:
CREATE DATABASE name;
Parameters: name: It is used to specify the name of the database to be created. The database name, table name, and table fields’ names in MySQL are case-sensitive.
Example:
CREATE DATABASE stores;
Explanation: A new database with the name ‘stores’ will be created in MySQL. All the existing databases can be checked using the below query. SHOW DATABASES;
