原因:
新版MySQL镜像修改了默认加密插件,我们要修改插件后才能正常通过外网访问。
解决方案:
grant all PRIVILEGES on *.* to root@'%' WITH GRANT OPTION;
ALTER user 'root'@'%' IDENTIFIED BY 'yourpassword' PASSWORD EXPIRE NEVER;
ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
flush privileges;
网友评论