Slave_IO_Running: No
Slave_SQL_Running: No
Slave_IO_Running: No
直接重置slave
stop slave;
reset slave;
start slave;
![](https://i-blog.csdnimg.cn/blog_migrate/1880239f773a7db535dd334546b3e843.png)
![](https://i-blog.csdnimg.cn/blog_migrate/d379b4626fcef9f9413df83db9e2c812.png)
Slave_SQL_Running: No
1)停掉slave
stop slave;
跳过错误步数,后面步数可变
set global sql_slave_skip_counter=1;
3)启动slave
start slave;
4)查看同步状态
show slave status\G;
![](https://i-blog.csdnimg.cn/blog_migrate/46d0787d7169765cb1ee32e5f0c70cd2.png)