本文主要是介绍Slave_SQL_Running:No，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

Linux下MySQL主从同步故障：“Slave_SQL_Running:No“的解决方法

可能有已下几种情况:

1. 在配置slave同步时因为slave访问master没有权限导致；

2. master上的mysql-bin.xxxxxx文件误删除；

3.

查看日志文件： tail /var/log/mysqld.log

2022-01-23T17:52:40.193201Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000001' at position 4, relay log './MiWiFi-R4CM-srv-relay-bin.000001' position: 4
2022-01-23T17:52:40.195821Z 2 [Note] Slave I/O thread for channel '': connected to master 'root@192.168.31.200:3306',replication started in log 'mysql-bin.000001' at position 4
2022-01-23T17:52:40.197235Z 2 [ERROR] Slave I/O for channel '': Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. Error_code: 1593
2022-01-23T17:52:40.197247Z 2 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000001', position 4
2022-01-23T17:52:46.936852Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2022-01-23T17:53:28.859945Z 6 [Warning] IP address '192.168.31.123' could not be resolved: Name or service not known
2022-01-23T18:09:12.012742Z 9 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2022-01-23T18:09:12.014234Z 9 [Note] Slave I/O thread for channel '': connected to master 'root@192.168.31.200:3306',replication started in log 'mysql-bin.000001' at position 4
2022-01-23T18:09:12.015682Z 9 [ERROR] Slave I/O for channel '': Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. Error_code: 1593
2022-01-23T18:09:12.015700Z 9 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000001', position 4

这篇关于Slave_SQL_Running:No的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！