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;