Resetting the MySQL root password in WebHost Manager (WHM)

This article describes how to reset the MySQL root password using WebHost Manager (WHM). You may need to do this, for example, if you have forgotten the password.

📘

Note

• You must have root access on the server to reset the MySQL root password.

• Remember that the MySQL root password is different from the root account password. The following procedure only changes the password for the MySQL root user, not the server's root user.

Resetting the MySQL root password

To reset the MySQL root password using WHM, follow these steps:

1. Log in to WebHost Manager.

   📘

   Note

   If you do not know how to log in to your WebHost Manager account, please see this article.

2. In the search box at the upper left of the WHM screen, start typing mysql root, and then click MySQL Root Password when it becomes visible:
   

3. In the Password and Password (again) text boxes, type the new password:
   

   👍

   Tip

   Alternatively, you can click Password Generator and WHM generates a strong, random password for you.

4. Click Change Password. The new MySQL root password takes effect immediately.

More Information

To view the official cPanel documentation about changing the MySQL root password, please visit https://blog.cpanel.com/how-to-reset-the-mysql-root-password-and-mysql-user-passwords.

Related Articles

• Resetting the MySQL root password

• Configuring remote MySQL access

• Connecting to MySQL from the command line

• Remote MySQL connections

• Restricting MySQL port access