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注销掉就可以了。或者直接删除。

 

 

posted @ 2013-04-26 16:53  破军  阅读(165)  评论(0编辑  收藏  举报