Knowledge Base
MilesWeb / Database

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

Approx. read time : 3 min

Watch this video for a step by step process on How to Change a MySQL Database User’s Password in cPanel

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.

Avatar
Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.