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!

Click To Load Comments

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

More Posts related to MySQL,

• MySQL Workbench could not detect any MySQL server running. This means that MySQL is not installed or is not running.
• Fix: pip install mysqlclient error: subprocess-exited-with-error
• [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
• MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
• MySQL: Error Code: 1175 You are using safe update mode
• Display List of Databases in mysql Command Line
• How to install MySQL Workbench on Mac (M1/M2)
• [macOS] Fix: MySQL ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)
• [Fix] MySQL No database selected - ERROR 1046 (3D000)
• MySQL: How to know which Database Schema you are on in Terminal
• MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
• MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
• Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
• MySQL Workbench - Connection Warning - Incompatible/nonstandard server version or connection protocol detected
• MySQL: How to Select Database via Terminal/Command Line
• MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
• Connection Failed: 1130 PHP MySQL Error
• Identify MySQL version in MySQL Command Line Prompt
• Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
• MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
• [fix] Loading class com.mysql.jdbc.Driver is deprecated
• How to Create Database in MySQL
• MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
• How to query database table names [MySQL/Oracle/SQL Server]
• How to clear MySQL Console Screen

More Posts:

• TextEdit: Disable Autocorrect Option (Mac) - MacOS
• How to check zsh installed version using terminal - MacOS
• How to delete SharePoint Online List Item using REST API - SharePoint
• How to use HashTags # correctly on Social Media Facebook Twitter - HowTos
• How to convert Milliseconds to Date in Java 8 and Above - Java
• How to List the SHA Digest of Docker Images - Docker
• SharePoint error cannot connect to the configuration database - SharePoint
• How to Identify installed PowerShell version - Powershell