stop slave
reset slave all; //彻底清除日志
CHANGE MASTER TO MASTER_HOST='192.168.1.210',
MASTER_USER='rep',MASTER_PASSWORD='rep',
MASTER_LOG_FILE='mysql-bin.000005',
MASTER_LOG_POS=1166
start slave;
show slave status;
SET GLOBAL sql_slave_skip_counter=1;
转载于:https://blog.51cto.com/yntmdr/1604911