着急,主从问题!Slave_IO_Running: No
下面是Mysql> show slave status \G;的部分输出信息:
Master_Log_File: mysql-bin.000076
Read_Master_Log_Pos: 4
Relay_Log_File: relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000076
Slave_IO_Running: No
Slave_SQL_Running: Yes
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master 'rel@192.168.250.20:3306' - retry-time: 60 retries: 86400
mysql错误日志描述:
101230 14:11:21 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='192.168.250.20', master_port='3306', master_log_file='mysql-bin.000076', master_log_pos='4'. New s
tate master_host='192.168.250.20', master_port='3306', master_log_file='mysql-bin.000076', master_log_pos='4'.
101230 14:11:26 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000076' at position 4, relay log './relay-bin.000001' position: 4
101230 14:11:26 [ERROR] Slave I/O: error connecting to master 'rel@192.168.250.20:3306' - retry-time: 60 retries: 86400, Error_code: 1045