How do I create a database user in cPanel?

Introduction

The MySQL database user is a record in the MySQL server that is created for authentication purposes. This is different from your usernames when you log in to Windows or even your cPanel/WHM. Setting up a MySQL user provides more security for your site's databases because you can assign permissions to each user. Apart from you, the site owner, you don't want to give every user all access to your database.

After the Create the database you need to create a user and assign permissions. Please note that MySQL user accounts are separate from Email and web administrator accounts must be created.

Video tutorial: How to create a database user

How do I create a database user in cPanel?

Before we can start you have to log in to the cPanel. If you don't know how to log in, we have a tutorial here as well: How to log in to the cPanel.

After you have logged in, in the Databases section click the icon MySQL databases.

On the next page you now scroll to ADD A NEW USER.

Now fill in the required fields.

Tip: Write down the username and password of the database on a notepad so that you can easily retrieve them when needed while manually installing a script.

Attention: The password will be displayed only once.

After that, the user must be linked to a database and the permissions must be assigned.

Link users to database

After the user has been created go back and scroll to ADD USER TO DATABASE

From the drop-down list, select the user and then the database to be linked. Then click Add.

You will be redirected to the next page where you have to grant the permissions.

Place the check mark in the desired position and then click the Change button.

Congratulations! You have just created a database user, assigned it to a database, and given it the necessary permissions.

We hope you found our tutorial useful and our instructions easy to understand. If you have any further questions, please do not hesitate to contact our Support Team to contact.