connect (master,localhost,root,,test,$MASTER_MYPORT,master.sock); connect (slave,localhost,root,,test,$SLAVE_MYPORT,slave.sock); connection master; reset master; grant replication slave on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab'; grant replication slave on *.* to replicate@127.0.0.1 identified by 'aaaaaaaaaaaaaaab'; connection slave; slave start; connection master; drop table if exists t1; create table t1(n int); insert into t1 values(24); save_master_pos; connection slave; sync_with_master; select * from t1; connection master; drop table t1; save_master_pos; connection slave; sync_with_master;