In cpanel

Login WHM —> mysql root password –> Given the new password.
cat /root/.my.cnf will list the password for mysql

In Kloxo

Search —> passwordMysql —> reset the password,

For manually changing

service mysqld stop

mysqld_safe –skip-grant-tables &

then exit from the mysql by typing quit
then type #mysql -u root mysql (Since you’ve skipped the grant table, this time when you try to login to mysql, it will not ask for password.)
Set MySQL Root Password to a New Password Using UPDATE Command below,

mysql> UPDATE user SET password=PASSWORD(‘newpassword’) WHERE user=’root’;

eg, mysql> UPDATE user SET password=PASSWORD(‘test123′) WHERE user=’root’;

then service mysql restart the mysql
then you can use the new mysql password “test1223”