MySQL忘记root密码怎么办？
MySQL如果忘记了root密码，可以很方便的找回，方法如下：
1.???? 先杀掉MySQL的所有进程；
#killall -TERM mysqld
?
2.??? 使用skip-grant-tables这个选项启动MySQL;
#/user/bin/safe_mysqld --skip-grant-tables &
?
3.? 这时你就可以不使用密码登陆MySQL了；
#mysql -h localhost -u root -p
mysql> use mysql
mysql> update user set password=password('newpassword') where user='root';?
mysql> flush privileges;
mysql> exit;?
?
4.??? 关闭MySQL；
?#/user/bin/mysqladmin -u root -p shutdown
Enter password:
STOPPING server from pid file /usr/local/mysql/data/ws01.pid
071218 11:30:19? mysqld ended
[1]+? Done??????????????????? /usr/local/mysql/bin/safe_mysqld --skip-grant-tables? (wd: /ceno/product/cacti/include)
(wd now: /usr/local/mysql/bin)
?
5.??? 正常启动MySQL；?
#/user/bin/mysqld_safe --user=mysql &
?[1] 5583
Starting mysqld daemon with databases from /usr/local/mysql/data
?
6.??? 现在赶快试试你的新密码吧；?
