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在重啟后也生效了

總結

以上是生活随笔為你收集整理的4、Mysql 主从复制报错[ERROR] [MY-013117] 踩坑的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。