Introduction

MySQL is an important part of any website empowered by PHP based applications, such as WordPress, Drupal, Joomla, Magento, etc. In this tutorial, we will guide you on how to create a new MySQL Database using the “MySQL Database Wizard” tool available in your cPanel account. By completing just a few simple steps, you will be able to create your new database, to assign a user to it and to determine the privileges you wish to grant it.

Getting Started

The first step we will need you to take is to log in to your cPanel account. You can achieve that by following another tutorial we have released - "How to access cPanel".

Once you are logged into your cPanel account, please navigate to the “Database” section and click on the “MySQL Database Wizard” icon.

Afterward, you will be redirected to the Wizard dashboard and you will need to complete four simple steps in order to create your new MySQL database.

Creating a new database

In the following lines, we will review each step of the database creation process separately in order to keep it consistent and explain everything in detail.

Step one: Defining the Database Name

In the first step, you will need to define your database name by entering the database suffix into the empty field. An important note to make is that all databases are assigned with a prefix based on the first eight characters of the cPanel username. This is done in order to ensure each database on the server has a unique name. The database name will be created in the following format “prefix_suffix”, for example, “armadatu_newdb”.

When you are ready, please click on the “Next Step” button.

Step two: Creating the Database User

In the second step, you will need to create the Database User which will be assigned to the database and used to manage it in the future. Please enter your database username and password in the corresponding fields. We would like to advise you to use the “Password Generator” tool which will generate a secure password for your database.

Also, please note that cPanel will not allow you to review the database password in the future, you will be able only to change it. Therefore, you might want to keep it stored on file.

When you are ready, please click on the “Create User” button.

Step three: Selecting the Database Privileges

In the third step, you will need to determine the privileges granted to the user. You can enable the required privileges by ticking the corresponding checkboxes next to them. Alternatively, if you would like to allow all privileges to the user you can directly click on the “ALL PRIVILEGES” checkbox. In case you are planning to assign this database to a website, in most cases, you will need to grant all privileges to the user.

When you are ready, please click on the “Next” button in order to finalize the database creation.

Step four: Task Completed

In the last, fourth step, you will be prompted with a message stating that your database was created and the user was successfully assigned to it.

Congratulations! You have managed to successfully create your new MySQL Database. Now, you are welcome to assign it to your project and start developing it. We hope you have found our tutorial useful and our instructions easy to follow. In case you have any additional questions, please do not hesitate to contact our Support Team.