Debian Codegraph @

mysql-test/suite/rpl/r/rpl_slave_status.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 ==== Create new replication user ====
7 [on master]
8 CREATE USER [email protected] IDENTIFIED BY 'rpl';
9 CREATE USER [email protected] IDENTIFIED BY 'rpl';
10 ERROR HY000: String 'rpluser_with_length_32_1234567890' is too long for user name (should be no longer than 32)
11 GRANT REPLICATION SLAVE ON *.* TO [email protected];
12 [on slave]
13 include/sync_slave_sql_with_master.inc
14 include/stop_slave.inc
15 CHANGE REPLICATION SOURCE TO SOURCE_USER='rpluser_with_length_32_123456789',
16 SOURCE_PASSWORD='rpl', GET_SOURCE_PUBLIC_KEY = 1, SOURCE_SSL = 1;
17 Warnings:
18 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
19 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
20 include/start_slave.inc
21 ==== Do replication as new user ====
22 [on master]
23 CREATE TABLE t1 (n INT);
24 INSERT INTO t1 VALUES (1);
25 [on slave]
26 include/sync_slave_sql_with_master.inc
27 SELECT * FROM t1;
28 n
29 1
30 ==== Delete new replication user ====
31 [on master]
32 DROP USER [email protected];
33 FLUSH PRIVILEGES;
34 [on slave]
35 include/sync_slave_sql_with_master.inc
36 ==== Restart slave without privileges =====
37 include/stop_slave.inc
38 START SLAVE;
39 Warnings:
40 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
41 include/wait_for_slave_sql_to_start.inc
42 include/wait_for_slave_io_to_stop.inc
43 ==== Verify that Slave IO thread stopped with error ====
44 include/wait_for_slave_io_error.inc [errno=1045]
45 [on master]
46 CREATE USER [email protected] IDENTIFIED BY 'rpl';
47 GRANT REPLICATION SLAVE ON *.* TO [email protected];
48 [on slave]
49 include/stop_slave.inc
50 CHANGE REPLICATION SOURCE TO SOURCE_USER='rpluser_plain', SOURCE_PASSWORD='rpl', SOURCE_SSL = 0, GET_SOURCE_PUBLIC_KEY = 1;
51 Warnings:
52 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
53 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
54 include/start_slave.inc
55 [on master]
56 DROP USER [email protected];
57 FLUSH PRIVILEGES;
58 [on slave]
59 include/stop_slave.inc
60 # Resetting replication user to root
61 include/stop_slave_sql.inc
62 Warnings:
63 Note 3084 Replication thread(s) for channel '' are already stopped.
64 CHANGE REPLICATION SOURCE TO SOURCE_USER = 'root', SOURCE_PASSWORD = '', SOURCE_SSL = 0;
65 Warnings:
66 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
67 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
68 include/rpl_reset.inc
69 # Replication Tests related to WL#9591 and WL#11057
70 # Check if replication takes place when slave user
71 # created with caching_sha2_pasword
72 [on master]
73 CREATE USER [email protected] IDENTIFIED WITH
74 'caching_sha2_password' BY 'pwd';
75 GRANT all ON *.* TO [email protected];
76 [on slave]
77 include/sync_slave_sql_with_master.inc
78 include/stop_slave.inc
79 # Set the user created with authentication plugin caching_sha2_password
80 # as replication slave user and get RSA public key from master
81 CHANGE REPLICATION SOURCE TO SOURCE_USER='u1_caching_sha2_password', SOURCE_PASSWORD='pwd', SOURCE_SSL=0, GET_SOURCE_PUBLIC_KEY = 1;
82 Warnings:
83 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
84 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
85 include/start_slave.inc
86 # Do replication with the user created with
87 # authentication plugin caching_sha2_password
88 [on master]
89 CREATE USER u2 IDENTIFIED WITH 'caching_sha2_password' BY 'pwd_u2';
90 # Below steps ensures that password is not cached initially and
91 # After successful login, it is cached. Hence same login statement
92 # with which login was denied earlier is allowed now
93 mysql: [Warning] Using a password on the command line interface can be insecure.
94 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
95 mysql: [Warning] Using a password on the command line interface can be insecure.
96 USER() CURRENT_USER()
97 u2@localhost u2@%
98 mysql: [Warning] Using a password on the command line interface can be insecure.
99 USER() CURRENT_USER()
100 u2@localhost u2@%
101 [on slave]
102 include/sync_slave_sql_with_master.inc
103 # On slave it is ensured that password cached on master is not replicated
104 # and after successful login on slave, it is cached
105 mysql: [Warning] Using a password on the command line interface can be insecure.
106 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
107 mysql: [Warning] Using a password on the command line interface can be insecure.
108 USER() CURRENT_USER()
109 u2@localhost u2@%
110 mysql: [Warning] Using a password on the command line interface can be insecure.
111 USER() CURRENT_USER()
112 u2@localhost u2@%
113 [on master]
114 FLUSH PRIVILEGES;
115 # Ensure that affect of FLUSH PRIVILEGE is propagated and cache from slave is also cleaned
116 mysql: [Warning] Using a password on the command line interface can be insecure.
117 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
118 [on slave]
119 include/sync_slave_sql_with_master.inc
120 mysql: [Warning] Using a password on the command line interface can be insecure.
121 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
122 [on slave]
123 include/stop_slave.inc
124 # Set the user created with authentication plugin caching_sha2_password
125 # as replication slave user and get RSA public key from master
126 CHANGE REPLICATION SOURCE TO SOURCE_USER='u1_caching_sha2_password', SOURCE_PASSWORD='pwd', SOURCE_SSL = 0, SOURCE_PUBLIC_KEY_PATH='MYSQL_TEST_DIR/std_data/rsa_public_key.pem', GET_SOURCE_PUBLIC_KEY = 0;;
127 Warnings:
128 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
129 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
130 include/start_slave.inc
131 # Do replication with the user created with
132 # authentication plugin caching_sha2_password
133 [on master]
134 CREATE USER u3 IDENTIFIED WITH 'caching_sha2_password' BY 'pwd_u3';
135 # Below steps ensures that password is not cached initially and
136 # After successful login, it is cached. Hence same login statement
137 # with which login was denied earlier is allowed now
138 mysql: [Warning] Using a password on the command line interface can be insecure.
139 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
140 mysql: [Warning] Using a password on the command line interface can be insecure.
141 USER() CURRENT_USER()
142 u3@localhost u3@%
143 mysql: [Warning] Using a password on the command line interface can be insecure.
144 USER() CURRENT_USER()
145 u3@localhost u3@%
146 [on slave]
147 include/sync_slave_sql_with_master.inc
148 # On slave it is ensured that password cached on master is not replicated
149 # and after successful login on slave, it is cached
150 mysql: [Warning] Using a password on the command line interface can be insecure.
151 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
152 mysql: [Warning] Using a password on the command line interface can be insecure.
153 USER() CURRENT_USER()
154 u3@localhost u3@%
155 mysql: [Warning] Using a password on the command line interface can be insecure.
156 USER() CURRENT_USER()
157 u3@localhost u3@%
158 [on master]
159 FLUSH PRIVILEGES;
160 # Ensure that affect of FLUSH PRIVILEGE is prpoagated and cache from slave is also cleaned
161 mysql: [Warning] Using a password on the command line interface can be insecure.
162 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
163 [on slave]
164 include/sync_slave_sql_with_master.inc
165 mysql: [Warning] Using a password on the command line interface can be insecure.
166 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
167 [on slave]
168 include/stop_slave.inc
169 ==== Cleanup (Note that slave IO thread is not running) ====
170 CHANGE REPLICATION SOURCE TO SOURCE_USER = 'root', SOURCE_PASSWORD = '', SOURCE_SSL = 0;
171 Warnings:
172 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
173 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
174 include/rpl_reset.inc
175 [on master]
176 DROP TABLE t1;
177 DROP USER [email protected];
178 DROP USER u2, u3;
179 include/rpl_end.inc