rpl000017.test 588 Bytes
Newer Older
1 2 3
source include/master-slave.inc;
connection slave;
stop slave;
4
connection master;
unknown's avatar
unknown committed
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