Error connecting to master, – retry time: 60 retries: 86400

Two virtual machines configured MySQL master slave when the virtual machine input
> show slave status\G;
Displays the following error
Last_IO_Error: error connecting to master ‘[email protected]:3307’ – Retry time: 60 Retry: 86400
I. Screening:
1. The username and password are correct
2. The port number of master is correct
3. Master authorization

# cat/data/mysql2/hostname. Err “to view the error log”

Slave I/O: ERROR connecting to master ‘[email protected]:3306’ – retry-time: 60 retry: 86400, Error_code: 2013
You don’t see anything. Error messages have no value.

Mysql – uslavelaowang – h192.168.32.133 – ppasswd
ERROR 2003 (HY000): Can’t connect to MySQL Server on ‘192.168.32.133’ (113)

# perror 113
OS Error code 113: No Route to host
【 Consider network reasons 】

# ping 192.168.32.133 [from the main ping] # Ping 192.168.32.132 [from the main ping] both have the return result, indicating network connection. Iptables -Fservice Iptables Save [Master Cleaning Firewall Rules]
Slave operation

# mysql – uslavelaowang h192.168.32.133 — ppasswd

ERROR 2003 (HY000): Can’t connect to MySQL Server on ‘192.168.32.133’ (111)

# perror 111
OS Error code 111: Connection union (union (union))
# mysql [Enter mysql under]
> slave stop;
> slave start;
> show slave status;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Return two Yes’s

Reason: Iptalbes firewall rules are not cleared.


Read More: