Mysql server – How to disable replication on slave ?
Sometimes, you want to remove the replication , it could be because the replication no longer works, or you don’t want to replicate. Here are some commands that you can use Login to mysql: mysql -uroot -p Enter your mysql root password Run the following command to disable the replication with master. STOP SLAVE; RESET SLAVE; change master to master_host=”, master_user=”, master_password=”; On the master, if you want to disable the replication you should login to mysql and run : stop master Delete all .bin file in /var/log/mysql Edit /etc/my.inf and remove the replication sectionRead More →