Lost Database Password
Website software such as WordPress and Drupal or database management software such as Workbench requires a database user and a password for users to access your database. If you have forgotten the password for your database user, you can set a new password inside cPanel.
Setting a New Password for your MySQL User
Follow these steps to set a new password for a MySQL database user:
- Log in to cPanel.
- Click MySQL® Databases in the Databases section.
- Scroll down at the bottom and look for the Current Users section.
Tip: You may also locate the MySQL Users section by clicking Jump to MySQL Users.Note: If you do not know which user to edit while making changes to a website, you may view the user the site is connecting with its configuration file:
- Look for the MySQL user you want to update and click the Change Password next to it.
- Enter the new password in the Password field. The Password Strength Meter on the page will identify the strength of the password.
Note: You may use the Password Generator to generate a random and secure password.
- Click the Change Password button when finished.
Re-Configuring Your Code
If you need to reset the password to fix a website installation, the site's configuration file needs to be updated. Once the configuration file has been updated to reflect the new password, the site should work as it was prior.
Check the following article if you are unsure of where your configuration file is and need help locating the file you need to edit the database password: