5
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
9
8
Master_Host 127.0.0.1
11
Master_Port MASTER_PORT
13
Master_Log_File master-bin.000001
17
Relay_Master_Log_File master-bin.000001
23
Replicate_Ignore_Table #
24
Replicate_Wild_Do_Table
25
Replicate_Wild_Ignore_Table
40
Seconds_Behind_Master #
41
Master_SSL_Verify_Server_Cert No
47
10
change master to master_user='test';
52
Master_Port MASTER_PORT
54
Master_Log_File master-bin.000001
58
Relay_Master_Log_File master-bin.000001
64
Replicate_Ignore_Table #
65
Replicate_Wild_Do_Table
66
Replicate_Wild_Ignore_Table
81
Seconds_Behind_Master #
82
Master_SSL_Verify_Server_Cert No
92
Master_Port MASTER_PORT
104
Replicate_Ignore_Table #
105
Replicate_Wild_Do_Table
106
Replicate_Wild_Ignore_Table
110
Exec_Master_Log_Pos #
115
Master_SSL_Allowed No
121
Seconds_Behind_Master #
122
Master_SSL_Verify_Server_Cert No
130
Master_Host 127.0.0.1
132
Master_Port MASTER_PORT
134
Master_Log_File master-bin.000001
135
Read_Master_Log_Pos #
138
Relay_Master_Log_File master-bin.000001
140
Slave_SQL_Running Yes
144
Replicate_Ignore_Table #
145
Replicate_Wild_Do_Table
146
Replicate_Wild_Ignore_Table
150
Exec_Master_Log_Pos #
155
Master_SSL_Allowed No
161
Seconds_Behind_Master #
162
Master_SSL_Verify_Server_Cert No
16
include/start_slave.inc
19
include/stop_slave.inc
21
include/start_slave.inc
170
22
create temporary table t1 (a int);
23
include/stop_slave.inc
25
include/start_slave.inc
174
26
show status like 'slave_open_temp_tables';
175
27
Variable_name Value
176
28
Slave_open_temp_tables 1
29
include/stop_slave.inc
179
*** errno must be zero: 0 ***
180
31
change master to master_user='impossible_user_name';
184
33
include/stop_slave.inc
185
34
change master to master_user='root';
186
35
include/start_slave.inc
187
*** last errno must be zero: 0 ***
188
*** last error must be blank: ***
189
36
include/stop_slave.inc
190
37
change master to master_user='impossible_user_name';
194
39
include/stop_slave.inc
196
*** io last errno must be zero: 0 ***
197
*** io last error must be blank: ***
198
*** sql last errno must be zero: 0 ***
199
*** sql last error must be blank: ***