> 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.