navicat连接虚拟机Ubuntu系统上的MySQL出现:2003-Can’t connect to Mysql server on’192.168.245.129’(10061 Unknown error)
查找发现,MySQL的配置文件/etc/mysql/mysql.conf.d/mysqld.cnf
中
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
bind-address
项绑定了登陆的IP,所以需要注释掉即可
然后重启mysql
service mysql restart