Sunday, June 30, 2013

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"

No comments:

Post a Comment