How to Solve MYSQL ERROR 2003 (HY000): Can’t connect to MySQL server on “host” (10038)
Error when connecting to remote MySQL.
ERROR 2003 (HY000): Can’t connect to MySQL server ‘ip’ (10038)
View error type (Linux systems)
perror 113
1
The results are as follows:
OS error code 113: no route to host
The reason for this error is that the server-side firewall does not open the port used by MySQL program. The default is 3306, and the port can be opened
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
1
Save the settings and restart the firewall
service iptables save
service iptables restart
Linux Set up open 3306 port solution
Firewall
Enable: service iptables start
Shutdown: service iptables stop
Turn off the firewall for a long time
On: chkconfig iptables on
Turn off: chkconfig iptables off
/sbin/iptables -I INPUT -p tcp –dport 3306 -j ACCEPT #Open port 3306
/sbin/iptables -A INPUT -p tcp –dport 80 -j ACCEPT #Enable port 80
/sbin/iptables -A INPUT -p tcp –dport 22 -j ACCEPT #Open port 22
My local machine is Ubuntu, and I can open it by just typing the above command
/etc/rc.d/init.d/iptables save #Save the configuration
/etc/rc.d/init.d/iptables restart #restart the service
View open ports
/etc/init.d/iptables status
The result is as follows
Table: filter
Chain INPUT (policy ACCEPT)
num target prot opt source destination
2 ACCEPT tcp — 0.0.0.0/0 0.0.0.0/0 tcp dpt:22
3 ACCEPT tcp — 0.0.0.0/0 0.0.0.0/0 tcp dpt:80