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

Leave a Reply

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