mysql stop slave io_MySQL主从配置This operation cannot be performed with a running slave io thread; run ...

MySQL主从配置This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '' first.

报错界面:

摆错内容:

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

解决办法:

1.先关闭当前的slave;

mysql> stop slave;

2.检查主服务器的配置信息:

vi /etc/my.cnf

# 文件末尾查看追加

log-bin=master-bin

binlog-format=ROW

server-id=1

binlog-do-db=msb

3.查看主的状态信息,在主MySQL下:

mysql> show master status;

+-------------------+----------+--------------+------------------+-------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

+-------------------+----------+--------------+------------------+-------------------+

| master-bin.000009 | 154 | msb | | |

+-------------------+----------+--------------+------------------+-------------------+

1 row in set (0.00 sec)

记住Position,完成后重新关联:

change master to master_host='192.168.182.111',master_user='root',master_password='123456',master_port=3306,master_log_file='master-bin.000001',master_log_pos=154;

查看slave状态：

发现Slave_SQL_Running: No,这地方必须是两个yes才可以同步。

执行:

STOP SLAVE;

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

再查看slave状态:

slave_sql_running和Slave_IO_Running，分别负责slave mysql进程和与主机的io通信全部是yes,成功!