2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
grant replication slave on *.* to replssl@localhost require ssl;
8
create table t1 (t int);
10
change master to master_user='replssl',master_password='';
12
insert into t1 values (1);
16
change master to master_ssl=1 , master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem', master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem', master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem';
25
Master_Port MASTER_MYPORT
31
Relay_Master_Log_File #
37
Replicate_Ignore_Table #
38
Replicate_Wild_Do_Table
39
Replicate_Wild_Ignore_Table
48
Master_SSL_Allowed Yes
49
Master_SSL_CA_File MYSQL_TEST_DIR/std_data/cacert.pem
51
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
53
Master_SSL_Key MYSQL_TEST_DIR/std_data/client-key.pem
54
Seconds_Behind_Master #
55
Master_SSL_Verify_Server_Cert No
61
change master to master_user='root',master_password='', master_ssl=0;
63
drop user replssl@localhost;
69
Master_Port MASTER_MYPORT
75
Relay_Master_Log_File #
81
Replicate_Ignore_Table #
82
Replicate_Wild_Do_Table
83
Replicate_Wild_Ignore_Table
93
Master_SSL_CA_File MYSQL_TEST_DIR/std_data/cacert.pem
95
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
97
Master_SSL_Key MYSQL_TEST_DIR/std_data/client-key.pem
98
Seconds_Behind_Master #
99
Master_SSL_Verify_Server_Cert No
106
master_host="localhost",
108
master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem',
109
master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
110
master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem',
111
master_ssl_verify_server_cert=1;
113
create table t1 (t int);
114
insert into t1 values (1);
121
Master_Host localhost
123
Master_Port MASTER_MYPORT
126
Read_Master_Log_Pos #
129
Relay_Master_Log_File #
131
Slave_SQL_Running Yes
135
Replicate_Ignore_Table #
136
Replicate_Wild_Do_Table
137
Replicate_Wild_Ignore_Table
141
Exec_Master_Log_Pos #
146
Master_SSL_Allowed Yes
147
Master_SSL_CA_File MYSQL_TEST_DIR/std_data/cacert.pem
149
Master_SSL_Cert MYSQL_TEST_DIR/std_data/client-cert.pem
151
Master_SSL_Key MYSQL_TEST_DIR/std_data/client-key.pem
152
Seconds_Behind_Master #
153
Master_SSL_Verify_Server_Cert Yes