How to create MySQL Database via cPanel

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.

Accessing MySQL Database Wizard

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, “armtu_newdb”.

Entering the database name

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.

Creating the database user

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.

Determining the privileges

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.

Task completed screen

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.

Powered by BetterDocs