Knowledgebase
Grant User's Permission to database Print this Article
Once a network administrator 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.
Was this answer helpful?
Related Articles
Removing A MySQL User In Cpanel
In a scenario if you are not willing to delete the user from the database directly, you may...
In a scenario if you are not willing to delete the user from the database directly, you may...
Creating A MySQL Database
In order to avail seamless database functionalities, administrators create highly effective...
In order to avail seamless database functionalities, administrators create highly effective...
Adding MySQL Access Hosts
In Cpanel, a network administrator allows external web servers to access the MySQL database...
In Cpanel, a network administrator allows external web servers to access the MySQL database...
How To Remove A MySQL Database
Hosting experts suggest that you must remove any instance of MySQL from the server which are not...
Hosting experts suggest that you must remove any instance of MySQL from the server which are not...
Changing MySQL database collation
To overcome foreign character encoding issues you may change the MySQL collation in. Most obvious...
To overcome foreign character encoding issues you may change the MySQL collation in. Most obvious...
