Connection to remote MySQL error:
ERROR 2003 (HY000): Can’t connect to MySQL Server ‘IP’ (113)
View error types (Linux system)
perror 113
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 the MySQL program. By default, it is 3306 and the open port is ok
/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
Save the Settings and restart the firewall
service iptables save
service iptables restart
Read More:
- Remote sshd prompt: server unexpectedly closed network connection
- Online problem solving analysis
- Driver failed programming external connectivity on endpoint quirky_ allen
- Navicat remote connection SQL Server 2014 express report 08001 error
- The solution of centos7’s inaccessibility after installing nginx
- Firewall CMD command in CentOS 7
- The solution of centos7 in VMware virtual machine unable to access after installing nginx
- Failed to connect to remote VM. Connection reused. Connection reused: Connect
- Error connecting to master, – retry time: 60 retries: 86400
- How to Fix java.net.ConnectException: Connection refused: connect
- ERROR 2005 (HY000): Unknown MySQL server host
- solve java.net.ConnectException : Connection refused:connect report errors
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- Alibaba cloud builds FTP server 200 port command successful. Consider using PASV. 425 failed to establish connection
- Remote desktop 0x104 solution?
- Error — failed to start docker container, error iptables — wait – t nat
- ERROR 1040 (08004): Too many connections
- docker: Error response from daemon: driver failed programming external connectivity on endpoint
- In depth analysis of mysq exceeding the number of connections error 1040 (HY000): too many connections
- Server (for example: HTTP) has a large number of time_ Solutions to wait