How to create a MySQL database with cPanel

Introduction

MySQL is an important part of any website that uses PHP-based Applications like WordPress, Drupal, Joomla, Magento etc. is operated. In this tutorial we will show you how to create a new MySQL database using the "MySQL Database Wizard" that is installed in your cPanel account is available. In a few simple steps you can create your new database, assign a user to it and set the access rights.

Video tutorial: How to create a database

Start with login

The first thing you need to do is log in to your cPanel account. You can do this with the help of another tutorial we have published - "How to log in to cPanel«.

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

You will then be redirected to the wizard dashboard where you can create your new MySQL database in four simple steps.

Create a new database

Below we will go through each step of the database creation process individually to keep it consistent and explain everything in detail.

First step: setting the database name

First step: setting the database name
The first step is to set the name of your database by entering the database suffix in the empty field. It is important to note that all databases are given a prefix based on the first eight characters of the cPanel username. This ensures that each database on the server has a unique name. The database name is created in the following format: "prefix_suffix", e.g. "orcschweiz_newdb".

When you are done, please click the "Next Step" button.

Second step: Creating the database user

In the second step you need to create the database user that will be assigned to the database and with which the database will be managed in the future. Please enter your database user name and password in the appropriate fields. We recommend that you use the "Password Generator" tool, which will generate a secure password for your database.

Please also note that in the future you will no longer be able to view the database password in cPanel, but only change it. Therefore, keep it in a safe place.

When you are ready, please click the "Create User" button.

Third step: Selection of database permissions

In the third step, you specify which privileges the user should have. You can activate the desired privileges by clicking the corresponding check boxes. If you want to grant the user all rights, you can also click directly on the "ALL RIGHTS" checkbox. If you intend to assign this database to a website, in most cases you will need to grant the user all rights.

When you are done, click the "Next" button to finish creating the database.

Fourth step: task completed

In the last, fourth step, you will receive a message that your database has been created and the user has been assigned successfully.

Congratulations! You have managed to successfully create your new MySQL database. Now you can assign it to your project and start developing it. We hope you found our tutorial useful and our instructions easy to follow. If you have any further questions, please do not hesitate to contact our Support Team to contact.