This article outlines the process of granting a user all privileges in MySQL. The MySQL privilege system enables users to make specific modifications to a database following verification. Users can execute database actions like INSERT, SELECT, DELETE, and UPDATE, depending on the permissions granted in cPanel.
To grant a user all privileges in MySQL, follow these steps:
-
Log in to your cPanel account.
-
Navigate to the "Databases" section and select "MySQL® Databases."
-
Head to the “Add User To Database” section within the MySQL Users category. Select the user you want to grant rights to and the corresponding database. Then, click the "Add" button on the subsequent screen.
-
You will be directed to the "Manage User Privileges" section, allowing you to choose the user's privileges.
-
To assign all privileges to the user, tick the "ALL PRIVILEGES" box, and then click the "Make Changes" button.
-
The system will present a success message, confirming that the user's chosen privileges have been saved.
-
Select "Go Back" from the list at the bottom.
-
Subsequently, you will be redirected to MySQL® Databases. The "Privileged Users" column in the "Current Databases" table now includes the user to whom you've recently granted privileges.
That concludes the process! We hope you now understand how to grant a user all privileges in MySQL using cPanel. For further assistance, feel free to reach out to our support team, available 24x7 just for you.