How to Create Database in MySQL

The Syntax to create a database in MySQL Server is "CREATE DATABASE database_name;"

Create Database Syntax:

CREATE DATABASE database_name;

Let us see a few examples of different ways in which you can create one,

Example 1: Using the mysql prompt in Terminal

on macOS/Linux/Windows:

mysql> Create Database mydb1;

Example 2: Using MySQL Workbench

1. Open MySQL Workbench.
2. In a Query Tab, enter the command:

   Create Database mydb2;

3. Click on the execute icon.
   
4. The logs will look like this,

   02:08:15 Create Database mydb2	1 row(s) affected	0.0061 sec

5. Go to Schema tab and hit the refresh icon and you should see the newly created database.

-

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X