The SQL CREATE DATABASE Statement
Create a new database using an SQL query.
Steps:
- Open phpMyAdmin in your system.
- Click on the SQL tab.
- Paste the query
CREATE DATABASE Testingdatabase;
. - Click the "Go" button.
- You should see a success message.
- Refresh the page to check if the database was created successfully.


Syntax
CREATE DATABASE Data_base_name;
Example of creating a database:
The following SQL statement creates a database called "Testingdatabase":
CREATE DATABASE Testingdatabase;
Tip:
Make sure you have admin privileges before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;