Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  Database  >  How To Change a MySQL Database User’s Password in cPanel?
Top Scroll

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

 2 min

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:

  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.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.