For some certain reasons, lots of people tend to find it a little difficult messing around databases or finding their way around setting up MySQL databases, users and how to set privileges to the users.

In this tutorial, I’ll guide you through the simple step by step processes involved in achieving the procedure in the shortest possible time.

Below are the steps you need to follow.

MySQL Database management

1. Login to your cPanel dashboard.

2. Click on MySQL Database Wizard.

MySQL database wizard

3. In the Create database tab, fill in the name of the new MySQL database you are about to create.

creating a database

4. Now the wizard would take you to the creating mysql user process after clicking Next Step. Fill in the username and password you wish to use then click on Create User.

creating mysql user

5. It’s time to assign or set privileges to the user. Click on All Privileges to check all permissions for the said user you created and hit the Next Step button.

set user privileges

6. The new page that would load up confirms that the user privileges has been set.

Done database

7. And that’s how to setup your database and user with privileges.

I hope you find this tutorial helpful.



Please enter your comment!
Please enter your name here