mySQL 5.0.11 sources for tomato
[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / r / rpl_stm_reset_slave.result
blob1fc189975ef2ab2e682968a464723e53fce65c56
1 stop slave;
2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3 reset master;
4 reset slave;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6 start slave;
7 Master_User     root
8 Master_Host     127.0.0.1
9 include/stop_slave.inc
10 change master to master_user='test';
11 Master_User     test
12 Master_Host     127.0.0.1
13 reset slave;
14 Master_User     root
15 Master_Host     127.0.0.1
16 include/start_slave.inc
17 Master_User     root
18 Master_Host     127.0.0.1
19 include/stop_slave.inc
20 reset slave;
21 include/start_slave.inc
22 create temporary table t1 (a int);
23 include/stop_slave.inc
24 reset slave;
25 include/start_slave.inc
26 show status like 'slave_open_temp_tables';
27 Variable_name   Value
28 Slave_open_temp_tables  1
29 include/stop_slave.inc
30 reset slave;
31 change master to master_user='impossible_user_name';
32 start slave;
33 include/stop_slave.inc
34 change master to master_user='root';
35 include/start_slave.inc
36 include/stop_slave.inc
37 change master to master_user='impossible_user_name';
38 start slave;
39 include/stop_slave.inc
40 reset slave;