mysql主从同步报错: The slave I/O thread stops because master and slave have equal MySQL server UUIDs
这是因为主从使用了相同的id造成的
检查主从server_id
主库:
mysql> show variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id | 1 |
+---------------+-------+
1 row in set (0.01 sec)
从库:
mysql> show variables like 'server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id | 2 |
+---------------+-------+
1 row in set (0.01 sec)
如果主从的server_id都相同,则进入my.ini或my.cnf进行修改一下即可。