ERROR 3021 (HY000): This operation cannot be performed with a running replica io thread； 配置主从错误解决

如果配置主从时，发生如下报错

原因：

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

执行如下命令

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> reset master;
Query OK, 0 rows affected (0.01 sec)

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

 

mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show slave status\G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.142.147
                  Master_User: itcast
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: binlog.000009
          Read_Master_Log_Pos: 840
               Relay_Log_File: salve2-relay-bin.000002
                Relay_Log_Pos: 323
        Relay_Master_Log_File: binlog.000009
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes

问题解决！