首页 > 其他分享 >(转)ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP S

(转)ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP S

时间:2023-01-02 16:44:53浏览次数:49  
标签:slave thread SLAV HY000 3021 io ERROR change

在mysql主从复制的时候,使用change to改变主从信息的时候,却发现change不了

提示

ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAV

ERROR 3021 (HY000):此操作不能在运行的从io线程中执行;运行停止slave

 

 

原因很简单,我们需要,先stop slave;先把slave  stop掉 然后再使用change就可以了。

change完之后,记得start slave; 开启slave


————————————————
版权声明:本文为CSDN博主「超级码农233」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/lslslsls77/article/details/127733240

标签:slave,thread,SLAV,HY000,3021,io,ERROR,change
From: https://www.cnblogs.com/NuoChong/p/17020120.html

相关文章