2003 - Can't connect to MySQL server on 'localhost' (10038)

Question

I installed mysql server in my ubuntu virtual machine, then I use Navaicat for Mysql to connet mysql, but failed. Navicat for Mysql is installed on Windows 7, Navicat version is 11.0.10, enterprise edition mysql is installed in my virtual machine, the system is Ubuntu 12, when I connect the mysql server, it returns:

my navicat connection configuration:

I tried several methods, including use the command: grant all privileges on . to 'root'@'%' identifed by 'passwd' with grant option and I shutdown the firewall of ubuntu using: ufw disable and I hava also shutdown the firewall of windows 7, the state of port 3306 of the ubuntu server is:

the iptable rules is like this:

the mysql.user table is like this:

but still, the navicat gives me the error: 2003 - can't connect to mysql server on 'localhost' (10038)

anyone can help me? thank you!

Answer 1

I solved this problem. In my /etc/mysql/my.cnf, the command bind the locahost address like this: bind-address=127.0.0.1, just add a # before it. and now I can connect to the mysql server smoothly.