Navicat MySQL connection Linux under the problem of MySQL solution

Error1:2003:can ' t connect to MySQL server on ' localhost '

Workaround: Turn off the firewall feature of Linux.

Linux Code

1. #Chkconfig iptables off
2. #Reboot

Error2:1130-host ' ClientIP ' isn't allowed to connect to this MySQL server

Workaround: Use the root user to log on to Linux and change the range of IP addresses allowed to login.

MySQL Code

1. Mysql>Grant all privileges on * * to ' root ' @'% ' identified by ' rootpasswd ' with GRANT option;

This instruction allows all users to enter the MySQL server with the root user password, if the '% ' transfer ' 192.168.1.124 ', then only ' 192.168.1.124 ' host can log in.  

now re-use Navicat to connect to Linux MySQL to succeed.