docker下mysql远程访问遇到的问题

1.ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.165' (113)

   防火墙问题

   systemctl disable firewalld

   service firewalld stop

 

2.ERROR 1045 (28000): Access denied for user 'root'@'172.17.0.1' (using password: YES)

   在关闭防火墙之后再重新赋予下远程连接的权限

   grant all privileges on *.* to root@'%' identified by '123456' with grant option; 

   flush privileges;

   exit

 

学习来源：

     https://www.cnblogs.com/xphdbky/p/7081582.html

     https://blog.csdn.net/metheir/article/details/85238801