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

作者：凡人多烦事01 | 2024-02-28 17:10:41

踩

error 3021 (hy000): this operation cannot be performed with a running slave

mysql创建从节点出现如下报错

ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '' first.

原因：

因为之前已经创建过主节点，需停掉之前的配置再重新配置

执行如下命令


stop slave;
reset master;

再次配置主从即可，查看从节点状态

show slave status\G

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/凡人多烦事01/article/detail/160416