|
1
by brian
clean slate |
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 |
grant replication slave on *.* to rpl@127.0.0.1 identified by 'rpl'; |
|
8 |
flush privileges; |
|
9 |
stop slave; |
|
10 |
change master to master_user='rpl',master_password='rpl'; |
|
11 |
start slave; |
|
12 |
drop table if exists t1; |
|
13 |
create table t1 (n int); |
|
14 |
insert into t1 values (1); |
|
15 |
select * from t1; |
|
16 |
n
|
|
17 |
1
|
|
18 |
drop user rpl@127.0.0.1; |
|
19 |
flush privileges; |
|
20 |
stop slave; |
|
21 |
start slave; |
|
22 |
show slave status; |
|
23 |
Slave_IO_State # |
|
24 |
Master_Host 127.0.0.1 |
|
25 |
Master_User rpl |
|
26 |
Master_Port MASTER_MYPORT |
|
27 |
Connect_Retry 1 |
|
28 |
Master_Log_File master-bin.000001 |
|
29 |
Read_Master_Log_Pos # |
|
30 |
Relay_Log_File # |
|
31 |
Relay_Log_Pos # |
|
32 |
Relay_Master_Log_File master-bin.000001 |
|
33 |
Slave_IO_Running No |
|
34 |
Slave_SQL_Running Yes |
|
35 |
Replicate_Do_DB
|
|
36 |
Replicate_Ignore_DB
|
|
37 |
Replicate_Do_Table
|
|
38 |
Replicate_Ignore_Table
|
|
39 |
Replicate_Wild_Do_Table
|
|
40 |
Replicate_Wild_Ignore_Table
|
|
41 |
Last_Errno 0 |
|
42 |
Last_Error
|
|
43 |
Skip_Counter 0 |
|
44 |
Exec_Master_Log_Pos # |
|
45 |
Relay_Log_Space # |
|
46 |
Until_Condition None |
|
47 |
Until_Log_File
|
|
48 |
Until_Log_Pos 0 |
|
49 |
Master_SSL_Allowed No |
|
50 |
Master_SSL_CA_File
|
|
51 |
Master_SSL_CA_Path
|
|
52 |
Master_SSL_Cert
|
|
53 |
Master_SSL_Cipher
|
|
54 |
Master_SSL_Key
|
|
55 |
Seconds_Behind_Master NULL |
|
56 |
Master_SSL_Verify_Server_Cert No |
|
57 |
Last_IO_Errno # |
|
58 |
Last_IO_Error # |
|
59 |
Last_SQL_Errno 0 |
|
60 |
Last_SQL_Error
|
|
61 |
drop table t1; |
|
62 |
drop table t1; |