Cancel MySQL salve settings

192.168.0.11 Master

     192.168.0.12Slave

The master server has a problem, so the master server is upgraded from the master server to the master server. in CNF, the master-host option of 192.168.0.12 is disabled. After restart, it is found that the slave status is always set, instead of the empty set

You cannot use reset slave.

 

You can use change master to master_host = ''to cancel the settings of the original slave. After the execution, the slave status can be changed to null.

Mysql> show slave status \ G
Empty set (0.00 Sec)

 

In mysql5.5, execute change master to master_host = '';

Error 1210 (hy000): Incorrect arguments to master_host

Stop slave

Slave stop;

Change master to master_host = '';