Help Center / Web Hosting

How to Create MySQL Databases in cPanel

Updated: November 27, 2023

  A MySQL database is simply a collection of structured data. MySQL creates a database for storing, manipulating data, and defining the relationship of each table.

In this guide, we will show you how to create MySQL Databases in cPanel.

Step 1

14% Complete (success)
Cpanel Login Screen

Log into your cPanel Account.

Step 2

28% Complete (success)
cPanel Databases MySQL

Navigate to Databases and click on MySQL Databases icon.

Step 3

42% Complete (success)
Create New Database

Under Create New Database section, simply indicate a name of the future database and click
on the Create Database button.

Step 4

56% Complete (success)
Add New MySQL User

Once the database is created, you will now need to create a MySQL User and assign it to the
database with the correct privileges.

To create a MySQL User, find the section MySQL Users - Add New User and choose a username
you want to assign to your database. Once done, choose a secure password for MySQL User and
type it into the corresponding fields.

Click Create User when done.

Step 5

84% Complete (success)
Add User to Database

Now you should have both MySQL Database and MySQL User created.
The next step is to assign a MySQL User to the database and set the correct privileges.

Find the Add User To Database section and make sure that you select the correct
Database and User correspondingly. Once done, simply click on the Add button.

Step 6

100% Complete (success)
Manage User Privileges

On the following page, you will need to set correct privileges to the MySQL User.
In this example, we shall grant all privileges to be able to maintain our MySQL Database
without any restrictions, so you simply need to choose the All Privileges option and click
on the Make Changes button.

Note: Multiple MySQL Users with different sets of privileges can be assigned to the same MySQL Database.