如果mysql的root密码忘了怎么办

原文链接:http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password

sudo /etc/init.d/mysqld stop

sudo mysqld_safe --skip-grant-tables &

mysql -u root

use mysql;

update user set password=PASSWORD("mynewpassword") where User='root';

flush privileges;

quit

/etc/init.d/mysqld stop

/etc/init.d/mysqld start

mysql -u root -p