4、Mysql 主从复制报错[ERROR] [MY-013117] 踩坑

最新推荐文章于 2025-05-07 14:17:16 发布

原创最新推荐文章于 2025-05-07 14:17:16 发布 · 5.1k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#mysql

MySQL 专栏收录该内容

4 篇文章

订阅专栏

在配置MySQL主从复制时遇到ERROR MY-013117，提示主从服务器ID相同导致复制失败。通过检查错误信息，意识到不能忽略此警告。最终通过更改server-id并调整权限成功解决问题，避免了警告并在重启后验证配置生效。

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!