mysql远程连接访问不了的问题记录i(1045 Access denied for user ‘root‘@‘localhost‘ (using password: YES)

1045 Access denied for user ‘root’@‘localhost’ (using password: YES)

grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
flush privileges;
SELECT * from mysql.user\G;

找到root用户的authentication_string这项，并把它的值记下来，然后继续执行以下命令
update mysql.user set authentication_string = ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’ where user = ‘root’;here user = ‘root’;
flush privileges;