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 section