How to Grant all Privileges to the User in cPanel

March 14, 2022 / cPanel & WHM

This article describes how to grant a user all privileges in MySQL. The MySQL privilege system allows a user to make particular modifications to a database after they have been verified. A user can perform database actions such as INSERT, SELECT, DELETE and UPDATE, based on the abilities allowed in cPanel.

To give a user all privileges in MySQL, follow these steps:

  1. Log in to your cPanel account.
    cPanel login
  2. From the Databases section, pick “MySQL® Databases”.
    MySQL® Databases
  3. Just go to the “Add User To Database” section under the MySQL Users section. Choose the User to whom you’d like to grant rights, as well as the Database to which you’d like to do so. Then, on the next screen, click the Add button.
    Add User To Database
  4. You’ll be taken to “Manage User Privileges”, where you can select the user’s privileges.
  5. To grant the user all privileges, check the ALL PRIVILEGES box and click the Make Changes button.
    ALL PRIVILEGES
  6. The system will display a success message, indicating that the user’s selected privileges have been saved.
    success
  7. Select Go Back at the bottom of the list.
    Go back
  8. Later, you’ll return to MySQL® Databases. The Privileged Users column in the Current Databases table contains the user you just granted privileges to.
    Database

That’s it! Hope you have understood how to grant a user all privileges in MySQL using cPanel. For assistance contact our support team which is available just for you 24×7.

Also Read: How to Set Privileges to a MySQL user Account in cPanel

Spread the love