Fatal 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

配置MySQL主从复制，遇到报错

 Fatal 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中的server-uuid是相同的（服务器是复制过去的）。

把从服务器中的auto.cnf重命名或者删除，然后重新启动MySQL，会重新生成auto.cnf文件。

然后重新grant赋权，change master就ok了。

Fatal 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

标签：sql   命名   mysq   master   mysql   复制   文件   uuid   thread