Disable MySQL Replication on Slave

To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql folder, remove entries like

Also, remove any entries starting with

Stop slave with command

Stop replication with

Stop MySQL

Remove relay logs

Start MySQL server

You may need to re-enable events that are disabled on Slave.

Enable each disabled event with

Example

Leave a Reply

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