本文共 1735 字，大约阅读时间需要 5 分钟。

2020-07-01T14:34:42.709318Z 12 [ERROR] [MY-013117] [Repl] Slave I/O for channel ‘’: 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 option must be used on slave but this does not always make sense; please check the manual before using it). Error_code: MY-013117

2020-07-01T14:34:42.709318Z 12 [ERROR] [MY-013117] [Repl] Slave I/O for channel '': 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 option must be used on slave but this does not always make sense; please check the manual before using it). Error_code: MY-013117

这个报错比较隐形，看着启停都是成功SUCCESS，所以之前都忽略了警告，

[root@localhost data]# service mysql stopmy_print_defaults: [Warning] World-writable config file '/etc/my.cnf' is ignored.Shutting down MySQL.... SUCCESS! [root@localhost data]# service mysql startmy_print_defaults: [Warning] World-writable config file '/etc/my.cnf' is ignored.Starting MySQL.my_print_defaults: [Warning] World-writable config file '/etc/my.cnf' is ignored.my_print_defaults: [Warning] World-writable config file '/etc/my.cnf' is ignored. SUCCESS!

后面不管怎么配置都没有生效，所以想起来可能不能忽略，然后尝试配置，更改权限后成功。

[root@localhost data]# ll /etc/my.cnf -rwxrwxrwx. 1 root root 613 Jul  1 08:32 /etc/my.cnf[root@localhost data]# chmod -R 755 /etc/my.cnf [root@localhost data]# ll /etc/my.cnf -rwxr-xr-x. 1 root root 613 Jul  1 08:32 /etc/my.cnf[root@localhost data]# service mysql restartShutting down MySQL.. SUCCESS! Starting MySQL.Logging to '/usr/local/mysql/data/mysql.log'. SUCCESS!

没有警告了，之前修改的server-id在重启后也生效了