MySQL主从报错处理（Last_IO_Error: 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 8.0.29

CentOS 7.6

 

VMware Workstation安装的MySQL 8.0数据库，为了实验手动复制的虚拟机，导致MySQL主从两端的mysql_uuid相同。

在启动MySQL Slave的时候报错：

Last_IO_Error: 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.

解决办法

到datadir路径下更新auto.cnf，然后重新启动MySQL服务即可。