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

1查看用户进程

ps -u mysql

2删除相关进程

kill -9 进程号

3启动mysql时不启动grant-tables

/usr/bin/mysqld_safe --skip-grant-tables &

4进入数据库

mysql

5修改管理员密码

use mysql

update user set password=password('yournewpasswordhere') where user='root';

flush privileges;

exit;

6重启服务

serivice mysql restart

7根用户登录

mysql -u root -p