How to Add MySQL Database User to a MySQL Database With Specific Privileges

This tutorial assumes that you have already created your database and database user.

1. Login to cPanel to accomplish this task.

2. Navigate to the “Databases” section and click on “MySQL Databases” .

image showing how to add mysl user to databse in cPanel

3. Go to the section written “Add User To Database” and select your user and the database you are assigning him to and click on the button “Add”.

image showing how to add mysql user to databse in cPanel

4. Select the privileges that you want this user to have, if you want them to do everything tick the “ALL PRIVILEGES” field at the top. Click on the button “Make Changes” to save.

image showing how to add mysql user to databse in cPanel

About the Author
HostPinnacle Kenya
HostPinnacle Kenya is the best and cheapest web hosting company in Kenya with world-class web hosting packages and affordable web design offers. Apart from that we offer free life-time SSL certificate, affordable domain registration in Kenya and free whois privacy. We have an award-winning support team available 24/7/365 to help you with your queries.

Leave a Reply