How to Grant all Privileges to a User in MySQL with cPanel?

• 11 October 2021
• in: MySQL

In a database The MySQL privilege system authenticates a user to make specific changes. Supported the privileges granted, a user will carry functions like SELECT, INSERT, UPDATE, DELETE etc. on the database. you’ll be able to access this method in cPanel.

To Grant all Privileges in MySQL with cPanel follow the steps as below:

Step 1. Log in to your cPanel account using login details.

Step 2. Navigate to the DATABASES section and click on MySQL® Databases.

Step 3. Scroll right down to the Add User To Database within the MySQL Users section. choose the user you wish to assign privileges and along with the database of your choice. Now, click the Add button.

Step 4. The system redirects you to Manage User Privileges, where you’ll be able to choose the privileges you wish the user to possess.

Step 5. Since we wish the user to possess all privileges, tick the ALL PRIVILEGES box and click on the Make Changes button. Successful message will flash indicating the system has saved the selected privileges for the user. From the bottom of the list Click on Go Back.

You will return to the MySQL® Databases. Here, you’ll be able to spot the user you simply granted privileges below the Privileged Users column of Current Databases table.