首页 > 代码库 > mysql添加从库报错slave have equal MySQL server UUIDs

mysql添加从库报错slave have equal MySQL server UUIDs

添加从库

问题出现情况1:复制的另一个从库的目录以及数据到新的从库,启动后报错: slave have equal MySQL server UUIDs


问题出现情况2:从主库复制目录以及数据到新的从库, 启动后报错: error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.


解决方法:删除新库目录下的auto.cnf文件,重启新库mysql服务


本文出自 “饿狼的传说” 博客,请务必保留此出处http://9548010.blog.51cto.com/9538010/1869337

mysql添加从库报错slave have equal MySQL server UUIDs