Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids

蚊子今天下午搭了一主三从的mysql复制，结果所有服务器都配置好后，发现从上报如下的错误 代码如下: Last_IO_Error: Fatal 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 opt

于是： 1、在主库中创建一个临时库，将需要导入的表文件复制过来 2、执行 create database tmpdb; create table tmptable; cp mysql_date_file master_data_file //shell command 复制数据表文件到master data_dir下 insert into master.tmptable select * from tmpdb.tmptable; 执行完后，主库中数据导入正常 再看slave status sh