linux下mysql root密码丢失

http://www.cnblogs.com/allenblogs/archive/2010/08/12/1798247.html

Ps:

UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;  更新密码时要使用password函数.我之前试了几次都不成功,后来才想起要使用password函数.

如果要把root的密码设置为root123.

update use set Password=password('root123') where User='root';