1.修改加密方式并更新密码
alter user 'root'@'%' identified with mysql_native_password by '123456';
如果没有就创建
create user 'root'@'%' identified with mysql_native_password by '123456';
2.授权远程访问
grant all privileges on *.* to 'root'@'%' with grant option;
3.刷新权限
FLUSH PRIVILEGES;
4、alter user 'root'@'%' identified with mysql_native_password by '123456';
mysql8 Navicat连接mysql8.0以上版本,报1045-Access denied for user ‘ ‘@‘ ‘ (using password: YES)
于 2022-10-24 18:35:15 首次发布