How To Change a MySQL Database User’s Password in cPanel?

Software for managing databases, like Workbench, or website builders, like WordPress and Drupal, require a password and database user in order for the user to access the database. It is feasible to change your database user’s password from inside cPanel if you can’t remember it.

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:

1. Log into cPanel and in the Databases section, click on MySQL Databases.
   
2. In the Current Users section, click on Set/Change Password next to the desired database user.
   
3. 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.