How to create a MySQL database with cPanel

Introduction

MySQL is an important part of any website that uses PHP-based Applications like WordPressDrupal, Joomla, Magento, etc. In this tutorial, we will show you how to create a new MySQL database using the "MySQL Database Wizard", which is available 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.

How to create a MySQL database with cPanel
cPanel Database Wizard

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 specify the name of your database by entering the database suffix in the empty field. It is important to know that all databases are given a prefix based on the first eight characters of the cPanel user name. 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".

How to create a MySQL database with cPanel
Create MySQL database

When you have finished, please click on the "Next step" button.

Second step: Creating the database user

In the second step, you must create the database user who will be assigned to the database and with whom the database will be managed in future. Please enter your database user name and password in the corresponding fields. We recommend that you use the "Password Generator" tool, which generates 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.

Create database
Create database user

When you are finished, please click on the "Create user" button.

Third step: Selection of database permissions

In the third step, you specify which rights the user should receive. You can activate the desired privileges by clicking on the corresponding checkboxes. 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, you must grant the user all rights in most cases.

database user
Grant database permissions

When you are finished, click on the "Next" button to complete the creation of 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.

Hat Ihnen diese Anleitung geholfen?