May it be website software such as WordPress and Drupal, or database management software such as Workbench, they need a database user and the password so that the user can access your database. In case you don’t remember the password for your database user, it is possible to set a new password from inside of cPanel.
Note: Another option to resetting the MySQL password is to find the existing password in your site’s configuration file.
Steps to Set a New Password for Your MySQL User
For setting a new password for a MySQL database user:
- Log into cPanel and in the Databases section, click on MySQL Databases.
- In the Current Users section, click on Set/Change Password next to the desired database user.
- Then enter a new password, re-enter the password and click on the Change Password button.
Note: You can also use the generate password button to randomly generate a secure password.
Re-Configuring Your Code
In case you need to reset the password to fix a website installation, it is important to update the site’s configuration file. After the configuration file is updated to reflect the new password, the site should work as it did earlier.
