搜索
您的当前位置:首页【Mysql】Navicat连接mysql8.0以上版本,报1045-Access denied for user ‘ ‘@‘ ‘ (using password: YES)

【Mysql】Navicat连接mysql8.0以上版本,报1045-Access denied for user ‘ ‘@‘ ‘ (using password: YES)

来源:世旅网

Navicat连接mysql8.0以上版本,报1045-Access denied for user ’ ‘@’ ’ (using password: YES)

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;

因篇幅问题不能全部显示,请点此查看更多更全内容

Top