配置从节点报错ERROR 3021 (HY000): Unknown error 3021

在设置MySQL从服务器时，设置从节点

mysql> change master to master_host='192.168.23.134',master_port=3306,master_user='root',master_password='love99',master_log_file='mysql-bin.000002',master_log_pos=154;

ERROR 3021 (HY000): Unknown error 3021

这是从服务器之前已经做过主从绑定，需要解绑

解决如下

mysql> stop slave;
Query OK, 0 rows affected (0.02 sec)

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

mysql>  change master to master_host='192.168.23.134',master_port=3306,master_user='root',master_password='love99',master_log_file='mysql-bin.000002',master_log_pos=154;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

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

mysql> show slave status\G

回报如下：

Relay_Master_Log_File: mysql-bin.000002
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
      Replicate_Do_DB: 

从服务器配置成功