mysql清除主从复制关系
封面图
•
2023-07-03
•
MySQL
178
0
0
0
1、清除主库上的复制信息: ``` mysql> RESET MASTER; ``` 2、清除从库的复制信息: ``` mysql> RESET SLAVE; ``` 3、在主库上清除从库的连接信息: ``` mysql> DELETE FROM mysql.user WHERE user='repl' and host='192.168.1.2'; ``` 4、在从库上清除主库的连接信息: ``` mysql> DELETE FROM mysql.user WHERE user='repl' and host='192.168.1.1'; ``` 5、在主库上重新创建从库的连接信息: ``` mysql> GRANT REPLICATION SLAVE ON *.* to 'repl'@'192.168.1.2' identified by 'password'; ``` 6、在从库上重新创建主库的连接信息: ``` mysql> GRANT REPLICATION SLAVE ON *.* to 'repl'@'192.168.1.1' identified by 'password'; ```
上一篇:
mySQL 错误 3167 - The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled;
下一篇:
mysql source导入多个sql文件
标题录入,一次不能超过6条
返回顶部
留言
留言
评论