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 stop my_print_defaults: [Warning] World-writable config file '/etc/my.cnf' is ignored. Shutting down MySQL.... SUCCESS! [root@localhost data]# service mysql start my_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 restart Shutting down MySQL.. SUCCESS! Starting MySQL.Logging to '/usr/local/mysql/data/mysql.log'. SUCCESS!没有警告了，之前修改的server-id在重启后也生效了
