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.
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 section