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. This is useful because you don’t need to know an existing password to change it to a new one.

This tool will allow you to change the passwords used by any system programs that need a database, such as roundcube. You will probably never need to know, use, or change these passwords, but it’s good to know how, just in case.

1) Go to the SQL Services menu.

2) Click Change a User or Database Password.

3) Select the MySQL user from the list. For system services, the username should reflect the application that uses it.

4) Enter and confirm a new password, or use the Password Generator.

5) Click Use Password.

6) Make note of the password, if you’ll need it.

7) Then, click Close.

8) When finished, click Change Password.

That’s it! The user’s password has been changed.

This completes the demonstration. You should now know how to manage MySQL user passwords in WHM.

  • 12 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 change the root MySQL password in WHM

When cPanel/WHM is set up, your system MySQL password is randomly generated. If you ever need...