How to change the root MySQL password in WHM

When cPanel/WHM is set up, your system MySQL password is randomly generated. If you ever need it, you can change it to something you’ll know.

1) Go to SQL Services in the menu.

2) Click MySQL Root Password.

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.

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

5) Then, click Regenerate.

6) And then Use Password.

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

8) Click Close.

9) Finally, click Change Password.

The root MySQL password should have been changed successfully.

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.

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.

Use this page in exactly the same way as the standard root password tool.

This is the end of the tutorial. You now know how to change the root MySQL password in WHM, and how to reset it if necessary.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to see details in WHM about the processes currently in use by MySQL

If you’ve noticed that MySQL seems to be responding sluggishly, one of your users may...

How to add MySQL access hosts in WHM

When granting a MySQL user access to a database, you have to specify which hosts are allowed...

What is a MySQL database?

A MySQL database, like all other types of databases, is used to keep track of a website or...

How to manage MySQL user passwords in WHM

There’s a page in WHM that allows you to manage all the MySQL passwords on your system....