MySOL的问题Access denide for user

Question

Access denide for user 'book'@'localhost'(using password:YES)
请问这个问题怎么解决

Answer 1

忘记密码
bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
bin/mysql -u root

use mysql;
UPDATE user SET Password=PASSWORD('123456') where USER='root';
flush privileges;
quit;

权任意机器，使用root账号登录，密码123456

select * from user \G
grant all on . to root@"%" identified by '123456';
flush privileges;
quit;