使用Navicat for Mysql连接Ubuntu虚拟机上的mysql服务器失败

Question

操作系统：windows 7
mysql所在虚拟机操作系统：Ubuntu 12
Navicat for Mysql版本：11.0.10 企业版
在虚拟机上用命令行连接mysql没问题
在windows 7上使用navicat连接报错：

有没有谁之前遇到过类似问题？

补充：
netstat查看端口状态：

iptables状态：

mysql.user数据库表状态：

Answer 1

I did it myself because I used bind-address=127.0.0.1 to bind the local address in my /etc/mysql/my.cnf file. Just comment out this sentence and it will be fine

Answer 2

Turn off the Linux firewall function, or set up to allow the 3306 port of the TCP protocol to pass

http://blog.libnav.com/sql/60.html
http://www.2cto.com/os/201203/124332.html

Answer 3

It’s no problem to connect to mysql using the command line on the virtual machine

Local link The local service uses NETBIOS analysis, of course it can be connected

Error when using navicat connection on Windows 7:

Then, there are many reasons for this.
1. Ping Ubuntu’s address to see if it can be reached? If not, check how the network settings of your virtual machine are set up. Then check whether the ubuntu firewall is turned off.
2. Ping is successful, but Mysql still cannot connect, check your Mysql authorization. Mysql's authorization for the account includes "user name" + "source address"

Answer 4

I also encountered this problem. It didn’t work even after reinstalling the system. I just installed the software. What are the connection steps?

How to use Navicat for Mysql to connect to the mysql server on the Ubuntu virtual machine - SegmentFault
http://segmentfault.com/q/1010000002648801

Answer 5

bind-address=127.0.0.1 is preceded by # and is authorized.