stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; stop slave;
grant replication slave on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab'; grant replication slave on *.* to replicate@127.0.0.1 identified by 'aaaaaaaaaaaaaaab';
start slave;
drop table if exists t1; create table t1(n int); insert into t1 values(24); select * from t1;
n 24
drop table t1;
delete from mysql.user where user="replicate";