navicat连接虚拟机Ubuntu系统上的MySQL出现:2003-Can't connect to Mysql server on '192.168.245.129'(10061 Unknown error)

2,172 阅读1分钟

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