取消主从关系
mysql -uroot -p
mysql>show slave status\G; 查看主库是否为之前的ip
mysql>change master to master_host=' ';
mysql>slave stop;
mysql>reset slave;
mysql>show slave status\G;
重新构建主从关系
mysql -uroot -p
mysql>stop slave;
mysql>change master to master_host=‘192.168.1.1’, master_user='repl', master_password=‘xxxxxxx’, MASTER_AUTO_POSITION = 1;
mysql>start slave;
master_host 为要更改主库的ip地址
master_password 为要修改的密码