In this tutorial we will show you how to change a database user's privileges in MySQL Databases, which is in cPanel. For example, you may need to grant full privileges to a database user.

Changing Privileges:

  1. Login to cPanel.
  2. Under the Databases section, click the MySQL Databases button.
  3. Under the Current Databases section, click the user that you want to modify the privileges for.  If you do not see the username, you may have to create the database user, and assign it to a database.
    choosing the user in mysql databases
  4. The MySQL Account Maintenance menu will open and allow you to choose the user's privileges. Click the check box next to the privileges you want to grant, or click the ALL PRIVILEGES box to grant full access.
    Choosing privileges for database user
  5. After making your selections, click the Make Changes button. You will see a notification stating "Their privileges have been updated."


Congratulations, now you know how to successfully update a database users privileges in MySQL Databases!


Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.