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 our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

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

News / Announcements

Update to SSL Certificates - Certificate Warnings
1969-12-31 11:00 am EST
Hits: 633
What is the Heartbleed bug?
1969-12-31 11:00 am EST
Hits: 261

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.