When user's creates a MySQL user, they must assign several permissions to those users for using any database whether MySQL or else. To accomplish the seamless execution, permissions are very necessary. Find below the steps to execute the permissions on the users.
- To access the MySQL Account Maintenance Menu, click on the icon MySQL Databases on the cPanel interface main screen.
- Select the user you wish to grant permissions for from the drop box next to User.
- Select the database you wish to give that user access to from the drop box next to Db.
- Select any privileges you wish the user to have by checking the box next to the privilege's name.
- Click on Add User to Db to give the user permission to access the database.
