Connection to remote MySQL error:
ERROR 2003 (HY000): Can’t connect to MySQL Server ‘IP’ (113)
View error types (Linux system)
perror 113The 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 restartRead More:
- Host is not allowed to connect to this MySQL server
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- ERROR 2005 (HY000): Unknown MySQL server host
- Can’t connect to MySQL server error 111
- Can’t connect to MySQL server on ‘192.168.64.132‘
- Error 2005 (HY000) unkonw MySQL server host…
- Sqlog connect to MySQL 8.0.24 remote server, error: 2058 solution
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- mysql problem solving: mysqladmin: connect to server at’localhost’ failed
- 2003 – Can‘t connect to MySQL server on ‘192.168.163.128‘(Unknown error )
- CentOS Liunx 7 uses rdesktop to remotely connect to the Alibaba Cloud server and it appears Failed to connect, CredSSP required by server.
- Error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061)
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- node.js Server MySQL database connection timeout (error: connect etimeout)
- MongoNetworkError: failed to connect to server [localhost:27017] on first connect [Error: connect EC
- The solution to the problem that the virtual machine and the host SSH can’t connect on vmvare