ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAV
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;rese
·
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
更多推荐
已为社区贡献5条内容
所有评论(0)