How to remove MySQL replication config from slave

We can stop the replication by running the following query in MySQL terminal.

>stop slave;

But the configuration will remains there and we can start the replication at any time.

If its required to remove the replication configurations completely, run the following query in MySQL terminal.

>reset slave all;

This will erase all the replication configurations.

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *