How to change MySQL root password from WHM?

In this article, we will describe steps to change the root password of MySQL server from WHM. This article is only applicable to Linux VPS and Dedicated server customers.

  1. Login to WHM with root user.
  2. Under SQL Services category. Locate and select MySQL Root Password option.

    Mysql root Password

  3. At next screen, you'll have to enter new MySQL root password.

    NOTE: MySQL root 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. 

    If you enter the password manually, make sure you use a combination of letters (upper and lower case), numbers and special characters. As you enter the new password in the box, Strength indicator will indicate how strong your password is. Alternatively, you can use the Password Generator to create a strong and random password.

    Reset Password

  4. Once you write down the new password in a safe place, click on the Change Password button. Upon successful password change, you will receive a screen stating your new password.

Related Articles

How to check active MS-SQL connections?

Following are the steps to check active database connection in the MS SQL server please follow...

How to increase max_user_connections in MySQL from Linux VPS?

More often you receive Too many connections error when you attempt to connect MySQL server. This...

How to Administrate MySQL Server with mysqladmin commands?

By using mysqladmin commands, you can perform basic MySQL tasks very easily, such as...

Fix - PHPMyAdmin Error You should upgrade to MySQL 5.5.0 or later

Problem statement Recently we upgraded phpMyAdmin version from 4.0.10.12 to 4.5.3.1 in our...

How to take a Backup and Restore of MySQL Databases via Command Line?

mysqldump is an easy and quick tool to create a backup of MySQL databases. It creates a dump file...

  • 0 Users Found This Useful

Was this answer helpful?