| 1 |
# ==== Purpose ==== |
| 2 |
# |
| 3 |
# Unknown. |
| 4 |
# |
| 5 |
# ==== Notes ==== |
| 6 |
# |
| 7 |
# This test uses the -slave.opt file to start the slave with |
| 8 |
# --skip-replica-start. |
| 9 |
|
| 10 |
--source include/not_group_replication_plugin.inc |
| 11 |
--source include/not_windows.inc |
| 12 |
|
| 13 |
--let $rpl_skip_start_slave= 1 |
| 14 |
--source include/set_privilege_checks_user_as_system_user.inc |
| 15 |
--let $rpl_privilege_checks_user_grant_option = 1 |
| 16 |
--source include/master-slave.inc |
| 17 |
|
| 18 |
--connection slave |
| 19 |
--let $slave_datadir= `SELECT @@datadir` |
| 20 |
|
| 21 |
--remove_file $slave_datadir/master.info |
| 22 |
--write_file $slave_datadir/master.info |
| 23 |
master-bin.000001 |
| 24 |
4 |
| 25 |
127.0.0.1 |
| 26 |
replicate |
| 27 |
aaaaaaaaaaaaaaab |
| 28 |
$MASTER_MYPORT |
| 29 |
1 |
| 30 |
0 |
| 31 |
EOF |
| 32 |
|
| 33 |
connection master; |
| 34 |
create user replicate@localhost identified by 'aaaaaaaaaaaaaaab', |
| 35 |
[email protected] identified by 'aaaaaaaaaaaaaaab'; |
| 36 |
grant replication slave on *.* to replicate@localhost; |
| 37 |
grant replication slave on *.* to [email protected]; |
| 38 |
connection slave; |
| 39 |
--source include/start_slave.inc |
| 40 |
|
| 41 |
connection master; |
| 42 |
create table t1(n int); |
| 43 |
insert into t1 values(24); |
| 44 |
--source include/sync_slave_sql_with_master.inc |
| 45 |
select * from t1; |
| 46 |
connection master; |
| 47 |
drop table t1; |
| 48 |
delete from mysql.user where user="replicate"; |
| 49 |
|
| 50 |
# End of 4.1 tests |
| 51 |
--source include/rpl_end.inc |
| 52 |
|
| 53 |
--source include/force_restart.inc |