How to reset 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.

  • 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.
    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:

    WebHost Manager - MySQL Root Password

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

    WebHost Manager - MySQL Root Password page

    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.

Get MySQL Hosting

Article Details

  • Operating System: Linux Hosting
  • Control Panel: cPanel
  • Level: Intermediate

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.