Tag Archives: MySQL ERROR 2003 (HY000)

[Solved] MYSQL ERROR 2003 (HY000): can’t connect to MySQL server (10060)

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

[Solved] MySQL ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

 

MySQL display error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061) solution

solution: the first step is to enter the bin directory of MySQL

cd C:\Program Files\MySQL\MySQL Server 5.5\bin

Input:

mysqld --skip-grant-tables

Open a new CMD, and then enter the bin directory:

cd C:\Program Files\MySQL\MySQL Server 5.5\bin

Input:

mysql -uroot

The problem has to be solved