如果配置主从时,发生如下报错
原因:
因为之前已经创建过主节点,需停掉之前的配置 再重新配置
执行如下命令
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
问题解决!