This article explains how to provide all privileges to a user in MySQL. The MySQL privilege system authenticates a user to make specific changes in a database. Based on the privileges granted in cPanel, a user can carry functions like SELECT, INSERT, UPDATE, DELETE, etc. on the database.
Follow these steps to provide all privileges to a user in MySQL:
1. Visit your cPanel account as well as log in.
2. Select MySQL® Databases from the Databases section.
3. In the MySQL Users section, scroll to the bottom to the “Add User To Database” section. Select the User to whom you want to assign rights, as well as the Database to which you want to assign them. After that, click the Add button.
4. You’ll be sent to “Manage User Privileges”, where you can choose which privileges the user should have.
5. Tick the ALL PRIVILEGES box and click the Make Changes button to give the user all privileges.
6. A success message will appear, indicating that the system has saved the user’s selected privileges.
7. At the bottom of the list, select Go Back.
8. You’ll return to MySQL® Databases later. The user you just gave privileges to can be found in the “Current Databases” table’s Privileged Users column.
In this way, you can grant all the privileges to a user in MySQL using cPanel. For any query contact our support staff and don’t forget to check our web hosting plans today.