navicat连接云服务器docker容器中的mysql

1.设置mysql访问权限

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | root             |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
4 rows in set (0.00 sec)

localhost有root权限，修改权限

update user set host = '%' where user ='root'; #修改权限
flush privileges;#刷新

2.检测云服务器是否开启了3306端口，这个端口是mysql对外的映射端口

阿里云服务器在工作区中，找到网络与安全，点击安全组，出入方向添加mysql端口

3.navicat连接mysql

先用SSL先连接上服务器，主机填云服务器公网ip，密码填服务器密码，点击确认

主机或ip填云服务器ip，密码填mysql密码，点击确认。