Navicat连接mysql8.0以上版本,报1045-Access denied for user ’ ‘@’ ’ (using password: YES)
1.修改加密方式并更新密码
alter user 'root'@'%' identified with mysql_native_password by 'abc.123';
abc.123:新密码
2.授权远程访问
grant all privileges on *.* to 'root'@'%' with grant option;
3.刷新权限
FLUSH PRIVILEGES;
4.重新用Navicat连接Mysql