Docker中新版mysql无法被主机和外网访问
2020-03-11 本文已影响0人
Dakini_Wind
原因:
新版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;