How To Create Database in MySQL

Databases allow you to store,retrieve and process data for business and other purposes. In this article, we will look at how to create database in MySQL.

Table of Contents

How To Create Database in MySQL

Here are the steps to create new database in MySQL using MySQL CREATE DATABASE command.

Here’s its syntax

CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name]

In the above query, database_name is the name of your new database. Please note, it must be unique to your MySQL server instance. Otherwise, you will get an error.

IF NOT EXISTS is an optional argument that checks if the database already exists and creates database only if it doesn’t exist.

CHARACTER SET option allows you to specify the character set to be used in MySQL database. By default, it is latin1. Similarly, the default COLLATION of MySQL database is latin_swedish_ci. If you want your database to support unicode characters then you will need to change its CHARACTER SET and COLLATION.

Bonus Read : How to Create Table in MySQL

MySQL CREATE DATABASE Examples

Here’s an example of how to create MySQL database.

mysql> create database testdb;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dashboard          |
| fedingo            |
| mysql              |
| performance_schema |
| sample             |
| test               |
| testdb             |
+--------------------+

mysql> use testdb;

Bonus Read : How to Add Foreign Key in MySQL

You can use USE database_name command to change your current active database. Hopefully, now you can create database in MySQL. You can use the above article to create database in PostgreSQL, SQL Server and Oracle also.

Ubiq makes it easy to visualize data in minutes, and monitor in real-time dashboards. Try it Today!

How to Find nth Row in MySQL

How to Add Auto Increment Column in Existing Table in MySQL

How To Alter Column From NULL to NOT NULL