https://jackxiang.com/index.php zh-cn https://jackxiang.com/post// jack <xdy108@126.com> Mon, 03 Feb 2020 14:29:44 +0000 https://jackxiang.com/post// stop slave;   reset slave; change master to master_host=' ';


mysql正确关闭slave取消主从同步
mysql> stop slave;  
Query OK, 0 rows affected (0.02 sec)

reset slave;
change master to master_host=' ';  #master_host=' ' 里面必须有内容，即使为空，也应该用空格代替，而不能什么都不写。

实践如下：
mysql> stop slave;   Query OK, 0 rows affected (0.02 sec) mysql> reset slave; Query OK, 0 rows affected (0.08 sec) mysql> change master to master_host=' '; Query OK, 0 rows affected (0.17 sec) mysql> show slave status\G;

参考：https://blog.csdn.net/guoshaoliang789/article/details/86217508 ]]> https://jackxiang.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://jackxiang.com/post//#blogcomment