<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">搜到一篇文章 用方法一解决 </span>
# /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: <输入新设的密码newpassword>
登录后 使用以下命令再次设置密码:
</pre><p></p><p><pre name="code" class="plain">mysql>SET PASSWORD = PASSWORD('123456')
原文地址: http://www.cnblogs.com/qq78292959/p/3641972.html
如需转载请注明原文出处