< All Topics

Change MySQL® User Password

  1. Log in toWHM >>SQL Services >>Change MySQL® User Password

1) Go to SQL Services in the menu.
frame02 1

2) Click MySQL Root Password.
frame03 1

Since this password can be used to gain access to every database on your system, you should set this to something that is very hard to guess. Preferably, use the password generator.

3) Enter and confirm the new password, or generate one.
frame05 1

4) Let’s change the password length to 24.
frame06 1

5) Then, click Regenerate.
frame07 1

6) And then Use Password.

7) Take note of the password and store it in a safe place.
frame08 1

8) Click Close.

9) Finally, click Change Password.
frame09 1

The root MySQL password should have been changed successfully.
frame10 1

10) If you received an error message, there is an alternative way to change the password. Click Reset Local MySQL Root Password.

11) Please take note of the warning. This tool should only be used as a last resort, if the other one won’t work.
frame11 1

Per the WHM documentation: This feature will result in a brief security risk to your server and an interruption of MySQL service; it should only be used as a last resort during times of low traffic, when you encounter a file permissions error using the MySQL Root Password feature.