我本机使用虚拟机Centos安装的docker,然后用docker部署mysql,防火墙关闭了,然后用户名也设置可以远程连接了,使用navicat连接时一直报10061.
mysql> select host,user,plugin,authentication_string from mysql.user;
+-----------+---------------+-----------------------+-------------------------------------------+
| host | user | plugin | authentication_string |
+-----------+---------------+-----------------------+-------------------------------------------+
| localhost | root | mysql_native_password | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| localhost | mysql.session | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys | mysql_native_password | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| % | root | mysql_native_password | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+---------------+-----------------------+-------------------------------------------+
这个是本机连mysql的时候报的错。
```>mysql -h 192.168.229.130 -uroot -p
Enter password: ******
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.229.130' (10061)
求各位大哥指条明路吧