MySQL - How to Create a Database?

MySQL: How to Create a Database

MySQL is a popular open-source relational database management system. It is widely used in web applications to store and retrieve data. In this article, we will learn how to create a database using MySQL.


Before we begin, you should have the following installed on your system:

  • MySQL server
  • MySQL client (command-line or graphical)

You should also have administrative privileges to create databases.

Creating a Database

To create a new database in MySQL, follow these steps:

  1. Open the MySQL client.
  2. Log in to the MySQL server using the following command:

mysql -u username -p

Replace username with your MySQL username. You will be prompted to enter your password.

  1. Once you are logged in, create a new database using the following command:

Replace dbname with the name you want to give to your database.

  1. Verify that the database has been created by using the following command:

This will display a list of all the databases on the MySQL server, including the one you just created.

Here’s an example of creating a database named mydatabase:


After executing the statement, the database mydatabase will be created in your MySQL server.

It’s worth mentioning that you need appropriate privileges to create a database. Typically, this privilege is granted to the MySQL root user or to a user with administrative privileges.

Once the database is created, you can use it by selecting it with the USE statement:

USE mydatabase;

From that point on, any subsequent SQL statements will be executed within the context of the selected database.

Remember that the CREATE DATABASE statement should be executed in the context of an existing MySQL server. If you’re using a MySQL client, make sure you’re connected to a MySQL server before attempting to create a database.

Create Database and Visually Manage MySql using DbSchema

DbSchema is a MySQL client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.

Connect to MySql alt >

Connect to MySQL

Start the application and choose to connect to the database. Choose MySql.

Create Database alt >

Create the Database

Choose the host (localhost if MySQL is installed on the current machine), enter the database user and password.

Create Database alt >

Enter the New Database Name

Choose the new database to create.

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.

Query Builder alt >

Query Builder

Create SQL Queries using the mouse.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme.


Creating a new database in MySQL is a simple process. You just need to log in to the MySQL server and use the CREATE DATABASE command to create a new database. Remember to replace dbname with the name you want to give to your database.