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.
Note: As an alternative to resetting the MySQL password, you may be able to find the existing password in your site's configuration file. If you are unsure where to locate the configuration file, please refer to our list of different scripts to find its location in the following article:
Setting a New Password for your MySQL User
To set a new password for a MySQL database user:
- Log in to cPanel and 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 are making changes to a website and do not know which user to edit, you may view the user the site is connecting within its configuration file:
- Look for the MySQL user you would like to update and click the Change Password right next to it.
- Enter the new password in the Password text box. The Password Strength Meter on the page will identify the strength of the password.
Note: You may use the generate password button to generate a secure password randomly.
- Click the Change Password Button when finished.
Re-Configuring Your Code
If you needed 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.
If you are unsure of where your configuration file is, the following article will help you locate the file you need to edit the database password within: