Introduction

MySQL is an important part of any website powered by PHP-based applications, such as WordPress, Drupal, Joomla, Magento, or any widely used PHP Framework, such as Laravel, Symphony, and Zend. In this tutorial, we will guide you towards creating a new MySQL Database using the “MySQL Database Wizard” tool available in your cPanel hosting account. By completing just a few simple steps, you will be able to create your new database, assign a user to it determine the privileges you wish to grant it so your application can properly communicate with its database.

Getting Started

The first step you will need to take is to log in to your cPanel account. You can achieve that by following a tutorial we have on How to access the cPanel service".

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

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

Creating a new database

In the following paragraphs, we will review each step of the database creation process separately in order to avoid confusion and explain everything in as much detail as possible.

Step one: Defining the Database Name

In the first step, you will need to define your database name by typing 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, “hatutorials_newdb”.

When you have typed in your database name, 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 will be 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 that will provide you with 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 set the privileges to the user, which will enable it to submit certain SQL queries and work with the database. You can enable the required privileges by placing a tick in the box corresponding 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 “Make Changes” 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 has been created and the user has been successfully assigned to it.

Below the prompt, you will notice a few useful links you can use to continue with your work:

• Add Another database - Please click on this link if you wish to add another database and go through the same process explained above.
• Add another user for your MySQL database - Please click on this link if you wish to add another user to the same MySQL database.
• Return to MySQL Databases - Please click on this link if you wish to return to the "MySQL Databases" functionality and view all your databases.
• Return Home - Please press this link if you wish to return to the cPanel home page.

Congratulations! You have managed to create your new MySQL Database successfully. 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.