rpl_000017.test 1.03 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
# ==== Purpose ====
#
# Unknown.
#
# ==== Notes ====
#
# This test uses the -slave.opt file to start the slave with
# --skip-slave-start.

--source include/not_windows.inc
--source include/not_master_info_table.inc

--let $rpl_skip_start_slave= 1
--source include/master-slave.inc

--connection slave
--let $slave_datadir= `SELECT @@datadir`

--remove_file $slave_datadir/master.info
--write_file $slave_datadir/master.info
master-bin.000001
4
127.0.0.1
replicate
aaaaaaaaaaaaaaab
$MASTER_MYPORT
1
0
EOF

connection 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;
--source include/start_slave.inc

connection master;
create table t1(n int);
insert into t1 values(24);
--source include/sync_slave_sql_with_master.inc
select * from t1;
connection master;
drop table t1;
delete from mysql.user where user="replicate";

# End of 4.1 tests
--source include/rpl_end.inc

--source include/force_restart.inc