DOCKER 连接MYSQL宿主机访问被拒
进入mysql容器:
# 进入mysql
mysql -u root -p
# 指定用户访问权限
mysql> grant all privileges on *.* to root@'%' with grant option;
# 远程连接认证密码
mysql> alter user 'root'@'%' identified by '新密码' password expire never;
# 本机认证密码
mysql> alter user 'root'@'%' identified with mysql_native_password by '新密码';
# 使修改立即生效
mysql> flush privileges;