docker mysql无法远程连接问题

linux centos7 安装docker后， 启动失败：https://docs.docker.com/install/linux/docker-ce/centos/

非root用户使用docker命令：将用户添加docker组，
gpasswd -a username docker

docker mysql 启动后无法远程连接：
docker run --name mysql01 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest

启动后用navicat无法连接，错误如下：

解决办法：

docker exec -it mysql01 bash
mysql -u root -p

(1) 查看用户信息

select host,user,plugin,authentication_string from mysql.user;
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| host      | user             | plugin                | authentication_string                                                  |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| %         | root             | caching_sha2_password | $A$005$wu)k:T&:	i%3_q-u=D2yi.Zt/nmvVUijtFm7hzFHK/UqC7W9RxMS9KHAFhh6 |
| localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.session    | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.sys        | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
N;}J&alhost | root             | caching_sha2_password | $A$005$ 
B5): L6^xTKlNIRYWKAdK2Mbn.G3LfJsDoVaZFDNRxo3MekXm98 |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
5 rows in set (0.01 sec)

mysql> 

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
Query OK, 0 rows affected (0.02 sec)
---------------------
mysql> select host,user,plugin,authentication_string from mysql.user;
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| host      | user             | plugin                | authentication_string                                                  |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
| %         | root             | mysql_native_password | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B                              |
| localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.session    | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.sys        | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
N;}J&alhost | root             | caching_sha2_password | $A$005$ 
B5): L6^xTKlNIRYWKAdK2Mbn.G3LfJsDoVaZFDNRxo3MekXm98 |
+-----------+------------------+-----------------------+------------------------------------------------------------------------+
5 rows in set (0.00 sec)

阿里云服务器配置后依然无法连接问题

配置安全规则

一切ok
ps：https://blog.csdn.net/qq_22211217/article/details/80415248?utm_source=copy
ps:http://www.chinastor.com/yw/04293QK2018.html