ERROR 1045 (28000): Access denied for user’root’@'localhost’(using password:YES)

能以mysql 进入但是mysqladmin和mysql -u root -p 输入密码却出现

ERROR 1045 (28000): Access denied for user’root’@'localhost’(using password:YES)

一是版本的问题，二是用户密码问题，我不记得安装时设置了root密码，很郁闷

1. 进入了mysql后输入：mysql -u root
2. 输入：use mysql
3. 输入：update user set password=old_password(‘mysql2011’) where user=’root’ and host=’localhost’ ;
4. 输入：FLUSH PRIVILEGES;