If you are having trouble connecting to a database or have forgotten a database user password you will want to reset that user's password. While there is no built-in way in cPanel to reset a password for a database user, you can accomplish a password reset by following the steps outlined here. What we will actually be doing is deleting the user and then recreating that same database user.

  1. Log into your cPanel 

  2. Select "MySQL Databases" in the Databases area of your cPanel home screen.

  3. cpanel-mysql-databases

  4. In the MySQL Databases screen, scroll down until you see the list of "Current Users."

  5. Before you delete the user you need to change the password for, make note of the last part of the user name (after the "_"). You can easily copy the name from your cPanel screen into a text editor so you can quickly reference it when you re-create that user.

  6. Click the red X in the delete column for the user you want to delete.

    mysql-database-users

  7. On the next screen click the "Delete User" button to confirm you wish to delete the database user.

    mysql-database-confirm-delete

  8. You will see a confirmation message that the user was deleted. Click on the "Go Back" link to return to the MySQL Databases screen.

  9. Under "Add New User" input the last part of the username of the user you just deleted and input a new password.

  10. mysql-database-add-user

  11. Click the "Create User" button and on the next screen receive the confirmation message that your user was created. Click on the "Go Back" link to return to the MySQL Databases screen.

  12. The last step is to assign the recreated database user to the database. Look for "Add User To Database" and select the user and the correct database from the drop down menus.

    mysql-database-add-user-to-db

  13. Click the "Add" button which will take you to the Manage User Privileges screen. 

  14. Select "All Privileges" for your user and click the "Make Changes" button.

  15. mysql-user-privileges

  16. You'll see the confirmation message that your user was added to the database.
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
Name

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

Name:
Email Address:
Phone Number:
Comment:
Submit

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com 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.