rpl000017.test 674 Bytes
Newer Older
monty@mysql.com's avatar
monty@mysql.com committed
1
connect (master,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
2
connect (slave,localhost,root,,test,$SLAVE_MYPORT,$SLAVE_MYSOCK);
3 4
connection master;
reset master;
5 6
grant replication slave on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab';
grant replication slave on *.* to replicate@127.0.0.1 identified by 'aaaaaaaaaaaaaaab';
7
connection slave;
8
start slave;
9
connection master;
10
--disable_warnings
11
drop table if exists t1;
12
--enable_warnings
13 14
create table t1(n int);
insert into t1 values(24);
15
sync_slave_with_master;
16 17 18
select * from t1;
connection master;
drop table t1;
19
delete from mysql.user where user="replicate";
20
sync_slave_with_master;
21 22

# End of 4.1 tests