How to create database in MySQL

The SQL CREATE DATABASE Statement

Create a new database using an SQL query.

Steps:

1. Open phpMyAdmin in your system.
2. Click on the SQL tab.
3. Paste the query CREATE DATABASE Testingdatabase;.

4. Click the "Go" button.
5. You should see a success message.
6. 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;