Tuesday, May 26, 2009

How to update user mysql using command line on windows

1. Quote : cd apache/mysql/bin

2. Quote : mysql -u root -p

3. Quote : use mysql

4. Quote : set password for 'root'@'localhost' = OLD_PASSWORD('newpassword');

5. Quote : update user set password = OLD_PASSWORD('newpassword') where Host = 'localhost' AND User = 'root';

6. Quote : flush privileges;

Enjoy ubuntu... ;)

No comments:

kunkun-laptop .... ;)