navicat连接数据库出现1045 access denied for user 'root'@'localhost' using password yes

navicat连接数据库出现1045 access denied for user 'root'@'localhost' using password yes

解决方案，亲测有效：

grant all privileges on *.* to 'root' @'%' identified by 'root' with grant option;

flush privileges;

如果上述不能解决，其他资料给的解决方案（未测试）：

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