You can change your MYSQL root password via WHM and shell. Please follow the bellow steps,

WHM :
——
Go to main > SQL Services > MySQL Root Password
This feature allows you to set a root MySQL password.

By default, no root password is set. You should ensure that a very secure password is used, because if this password were to be compromised, the attacker would have access to any database associated with your server. You will not need to remember this password unless you plan on logging into any of your databases as the root user.

To set the password:
——————–
1. Enter the desired password into the New Password field.
*You may also use the Password Generator by clicking Generate Password.
*You should ensure that a very secure password is used, because if this password were to be compromised, the attacker would have access to any database associated with your server.
*Do not use asterisks (*), periods (.), or any other special characters in your MySQL root password. If you do so, phpMyAdmin will not function. If you are using the Password Generator, you may wish to uncheck the Symbols checkbox.
2. Enter the password again into Password Again field.
3. Click the Change Password button.

If you have any issue, you can easily reset your MYSQL root password via the shell by following the bellow steps:
——————————————–
1. First make sure that mysql service is stop
/etc/init.d/mysql stop
2. Now run the following command from the shell.
/usr/bin/safe_mysqld –skip-grant-tables

If the above command gives the following result then refer to the command.

===========================================================
[email protected] [~] # /usr/bin/safe_mysqld –skip-grant-tables
-bash: /usr/bin/safe_mysqld: No such file or directory
===========================================================

/usr/bin/mysqld_safe –skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set Password = PASSWORD(‘supp0rt123′) where User=’root’;
mysql> exit
Now restart the mysql service

 /etc/init.d/mysqld stop
/etc/init.d/mysqld start

Then you can successfully reset your MYSQL root password

 

0.00 avg. rating (0% score) - 0 votes
Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive