when we lost the passwd of MySQL --neaten by Jacky

pxw212

What can we doing when lost the root's password of Mysql?
(or When you get error message :"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var")
--method 1:
mysqld＿safe－user＝mysql
--method 2:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password:   测验成功~~~
--method 3:
直接使用/etc/mysql/debian.cnf文件中[client]节提供的用户名和密码:
# mysql -udebian-sys-maint -p
Enter password:
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password:
--method 4: (haven't test)
# mysql -uroot -p
Enter password:
--method 5;
#cd /usr/local/mysql/bin (如果你的mysql不在这里的话就.....知道吧)
杀掉mysql
#kill -9 `ps -ax | grep mysql | awk '{print $1}'` (copy过去好了...省得...)
启动mysql
#./safe_mysqld -Sg &
进入mysql
#./mysql mysql (两个mysql哦)
改口令
>update user set Password = '' where User = 'root';
出来
>\q
再杀一次！
#kill -9 `ps -ax | grep mysql | awk '{print $1}'`
正常启动mysql
.#./safe_mysqld &
现在mysql中root口令为空。。。
要改成其他口令的话。。。 set password=PASSWORD('xxx')
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/14519/showart_321606.html