RESET MYSQL PASSWORD

RESET MYSQL PASSWORD

====================

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,

In Direct admin

==========

For manually change

=================

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"