mysql镜像外网访问出错

参考博客：https://blog.csdn.net/sanpic/article/details/80707918

报错1

• 客户端连接报错

• docker中MySQL容器日志

解决方法

alter user 'root'@'%' identified by '123456' password expire never;
alter user 'root'@'%' identified with mysql_native_password by 'root';

报错2

• 调整密码

alter user 'root'@'localhost' IDENTIFIED BY 'root';
alter user 'root'@'%' IDENTIFIED BY 'root';
flush privileges;