mysql主从配置出错

在从服务器上配置出现这个错误

error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).

mysql5.X默认开启了server-id

在/etc/my.cnf找到server-id注销掉就可以了。或者直接删除。

原文地址:https://www.cnblogs.com/potu/p/3045205.html