Debian Codegraph @

mysql-test/suite/group_replication/r/gr_variables_privileges.result

raw
1 include/group_replication.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 server1]
6
7 ############################################################
8 # 1. Create an user which lacks privileges.
9 [connection server1]
10 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
11 CREATE USER 'no_priv_user'@localhost IDENTIFIED BY '';
12 GRANT ALL ON *.* TO 'no_priv_user'@localhost;
13 REVOKE SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN, GROUP_REPLICATION_ADMIN
14 ON *.* FROM 'no_priv_user'@localhost;
15
16 ############################################################
17 # 2. Expect ER_SPECIFIC_ACCESS_DENIED_ERROR when setting GR
18 # global variables since user lacks SUPER or
19 # SYSTEM_VARIABLES_ADMIN privileges.
20 CREATE TABLE gr_vars (id INT PRIMARY KEY AUTO_INCREMENT, var_name VARCHAR(64), var_value VARCHAR(256));
21 INSERT INTO gr_vars (var_name, var_value)
22 SELECT * FROM performance_schema.global_variables
23 WHERE VARIABLE_NAME LIKE '%group_replication%'
24 ORDER BY VARIABLE_NAME;
25 [connection no_priv_user_con]
26
27 # Expect ER_SPECIFIC_ACCESS_DENIED_ERROR for global variables.
28 SET GLOBAL group_replication_advertise_recovery_endpoints = @@GLOBAL.group_replication_advertise_recovery_endpoints;
29 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
30 SET GLOBAL group_replication_allow_local_lower_version_join = @@GLOBAL.group_replication_allow_local_lower_version_join;
31 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
32 SET GLOBAL group_replication_auto_increment_increment = @@GLOBAL.group_replication_auto_increment_increment;
33 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
34 SET GLOBAL group_replication_autorejoin_tries = @@GLOBAL.group_replication_autorejoin_tries;
35 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
36 SET GLOBAL group_replication_bootstrap_group = @@GLOBAL.group_replication_bootstrap_group;
37 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
38 SET GLOBAL group_replication_clone_threshold = @@GLOBAL.group_replication_clone_threshold;
39 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
40 SET GLOBAL group_replication_communication_debug_options = @@GLOBAL.group_replication_communication_debug_options;
41 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
42 SET GLOBAL group_replication_communication_max_message_size = @@GLOBAL.group_replication_communication_max_message_size;
43 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
44 SET GLOBAL group_replication_communication_stack = @@GLOBAL.group_replication_communication_stack;
45 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
46 SET GLOBAL group_replication_components_stop_timeout = @@GLOBAL.group_replication_components_stop_timeout;
47 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
48 SET GLOBAL group_replication_compression_threshold = @@GLOBAL.group_replication_compression_threshold;
49 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
50 SET GLOBAL group_replication_consistency = @@GLOBAL.group_replication_consistency;
51 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
52 SET GLOBAL group_replication_enforce_update_everywhere_checks = @@GLOBAL.group_replication_enforce_update_everywhere_checks;
53 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
54 SET GLOBAL group_replication_exit_state_action = @@GLOBAL.group_replication_exit_state_action;
55 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
56 SET GLOBAL group_replication_flow_control_applier_threshold = @@GLOBAL.group_replication_flow_control_applier_threshold;
57 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
58 SET GLOBAL group_replication_flow_control_certifier_threshold = @@GLOBAL.group_replication_flow_control_certifier_threshold;
59 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
60 SET GLOBAL group_replication_flow_control_hold_percent = @@GLOBAL.group_replication_flow_control_hold_percent;
61 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
62 SET GLOBAL group_replication_flow_control_max_quota = @@GLOBAL.group_replication_flow_control_max_quota;
63 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
64 SET GLOBAL group_replication_flow_control_member_quota_percent = @@GLOBAL.group_replication_flow_control_member_quota_percent;
65 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
66 SET GLOBAL group_replication_flow_control_min_quota = @@GLOBAL.group_replication_flow_control_min_quota;
67 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
68 SET GLOBAL group_replication_flow_control_min_recovery_quota = @@GLOBAL.group_replication_flow_control_min_recovery_quota;
69 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
70 SET GLOBAL group_replication_flow_control_mode = @@GLOBAL.group_replication_flow_control_mode;
71 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
72 SET GLOBAL group_replication_flow_control_period = @@GLOBAL.group_replication_flow_control_period;
73 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
74 SET GLOBAL group_replication_flow_control_release_percent = @@GLOBAL.group_replication_flow_control_release_percent;
75 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
76 SET GLOBAL group_replication_force_members = @@GLOBAL.group_replication_force_members;
77 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
78 SET GLOBAL group_replication_group_name = @@GLOBAL.group_replication_group_name;
79 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
80 SET GLOBAL group_replication_group_seeds = @@GLOBAL.group_replication_group_seeds;
81 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
82 SET GLOBAL group_replication_gtid_assignment_block_size = @@GLOBAL.group_replication_gtid_assignment_block_size;
83 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
84 SET GLOBAL group_replication_ip_allowlist = @@GLOBAL.group_replication_ip_allowlist;
85 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
86 SET GLOBAL group_replication_ip_whitelist = @@GLOBAL.group_replication_ip_whitelist;
87 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
88 SET GLOBAL group_replication_local_address = @@GLOBAL.group_replication_local_address;
89 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
90 SET GLOBAL group_replication_member_expel_timeout = @@GLOBAL.group_replication_member_expel_timeout;
91 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
92 SET GLOBAL group_replication_member_weight = @@GLOBAL.group_replication_member_weight;
93 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
94 SET GLOBAL group_replication_message_cache_size = @@GLOBAL.group_replication_message_cache_size;
95 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
96 SET GLOBAL group_replication_paxos_single_leader = @@GLOBAL.group_replication_paxos_single_leader;
97 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
98 SET GLOBAL group_replication_poll_spin_loops = @@GLOBAL.group_replication_poll_spin_loops;
99 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
100 SET GLOBAL group_replication_recovery_complete_at = @@GLOBAL.group_replication_recovery_complete_at;
101 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
102 SET GLOBAL group_replication_recovery_compression_algorithms = @@GLOBAL.group_replication_recovery_compression_algorithms;
103 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
104 SET GLOBAL group_replication_recovery_get_public_key = @@GLOBAL.group_replication_recovery_get_public_key;
105 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
106 SET GLOBAL group_replication_recovery_public_key_path = @@GLOBAL.group_replication_recovery_public_key_path;
107 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
108 SET GLOBAL group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
109 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
110 SET GLOBAL group_replication_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
111 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
112 SET GLOBAL group_replication_recovery_ssl_ca = @@GLOBAL.group_replication_recovery_ssl_ca;
113 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
114 SET GLOBAL group_replication_recovery_ssl_capath = @@GLOBAL.group_replication_recovery_ssl_capath;
115 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
116 SET GLOBAL group_replication_recovery_ssl_cert = @@GLOBAL.group_replication_recovery_ssl_cert;
117 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
118 SET GLOBAL group_replication_recovery_ssl_cipher = @@GLOBAL.group_replication_recovery_ssl_cipher;
119 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
120 SET GLOBAL group_replication_recovery_ssl_crl = @@GLOBAL.group_replication_recovery_ssl_crl;
121 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
122 SET GLOBAL group_replication_recovery_ssl_crlpath = @@GLOBAL.group_replication_recovery_ssl_crlpath;
123 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
124 SET GLOBAL group_replication_recovery_ssl_key = @@GLOBAL.group_replication_recovery_ssl_key;
125 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
126 SET GLOBAL group_replication_recovery_ssl_verify_server_cert = @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;
127 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
128 SET GLOBAL group_replication_recovery_tls_ciphersuites = @@GLOBAL.group_replication_recovery_tls_ciphersuites;
129 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
130 SET GLOBAL group_replication_recovery_tls_version = @@GLOBAL.group_replication_recovery_tls_version;
131 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
132 SET GLOBAL group_replication_recovery_use_ssl = @@GLOBAL.group_replication_recovery_use_ssl;
133 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
134 SET GLOBAL group_replication_recovery_zstd_compression_level = @@GLOBAL.group_replication_recovery_zstd_compression_level;
135 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
136 SET GLOBAL group_replication_single_primary_mode = @@GLOBAL.group_replication_single_primary_mode;
137 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
138 SET GLOBAL group_replication_ssl_mode = @@GLOBAL.group_replication_ssl_mode;
139 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
140 SET GLOBAL group_replication_start_on_boot = @@GLOBAL.group_replication_start_on_boot;
141 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
142 SET GLOBAL group_replication_tls_source = @@GLOBAL.group_replication_tls_source;
143 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
144 SET GLOBAL group_replication_transaction_size_limit = @@GLOBAL.group_replication_transaction_size_limit;
145 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
146 SET GLOBAL group_replication_unreachable_majority_timeout = @@GLOBAL.group_replication_unreachable_majority_timeout;
147 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
148 SET GLOBAL group_replication_view_change_uuid = @@GLOBAL.group_replication_view_change_uuid;
149 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
150
151 # Like most system variables, setting the session value for
152 # group_replication_consistency requires no special privileges.
153 SET SESSION group_replication_consistency = @@SESSION.group_replication_consistency;
154
155 ############################################################
156 # 3. Grant SYSTEM_VARIABLES_ADMIN and verify setting group
157 # replication variables at global scope succeed, except
158 # group_replication_consistency which also needs
159 # GROUP_REPLICATION_ADMIN privilege.
160 [connection server1]
161 GRANT SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO 'no_priv_user'@localhost;
162 [connection no_priv_user_con]
163
164 SET GLOBAL group_replication_advertise_recovery_endpoints = @@GLOBAL.group_replication_advertise_recovery_endpoints;
165 SET GLOBAL group_replication_allow_local_lower_version_join = @@GLOBAL.group_replication_allow_local_lower_version_join;
166 SET GLOBAL group_replication_auto_increment_increment = @@GLOBAL.group_replication_auto_increment_increment;
167 SET GLOBAL group_replication_autorejoin_tries = @@GLOBAL.group_replication_autorejoin_tries;
168 SET GLOBAL group_replication_bootstrap_group = @@GLOBAL.group_replication_bootstrap_group;
169 SET GLOBAL group_replication_clone_threshold = @@GLOBAL.group_replication_clone_threshold;
170 SET GLOBAL group_replication_communication_debug_options = @@GLOBAL.group_replication_communication_debug_options;
171 SET GLOBAL group_replication_communication_max_message_size = @@GLOBAL.group_replication_communication_max_message_size;
172 SET GLOBAL group_replication_communication_stack = @@GLOBAL.group_replication_communication_stack;
173 SET GLOBAL group_replication_components_stop_timeout = @@GLOBAL.group_replication_components_stop_timeout;
174 SET GLOBAL group_replication_compression_threshold = @@GLOBAL.group_replication_compression_threshold;
175 SET GLOBAL group_replication_consistency = @@GLOBAL.group_replication_consistency;
176 ERROR 42000: Access denied; you need (at least one of) the SUPER or GROUP_REPLICATION_ADMIN privilege(s) for this operation
177 SET GLOBAL group_replication_enforce_update_everywhere_checks = @@GLOBAL.group_replication_enforce_update_everywhere_checks;
178 SET GLOBAL group_replication_exit_state_action = @@GLOBAL.group_replication_exit_state_action;
179 SET GLOBAL group_replication_flow_control_applier_threshold = @@GLOBAL.group_replication_flow_control_applier_threshold;
180 SET GLOBAL group_replication_flow_control_certifier_threshold = @@GLOBAL.group_replication_flow_control_certifier_threshold;
181 SET GLOBAL group_replication_flow_control_hold_percent = @@GLOBAL.group_replication_flow_control_hold_percent;
182 SET GLOBAL group_replication_flow_control_max_quota = @@GLOBAL.group_replication_flow_control_max_quota;
183 SET GLOBAL group_replication_flow_control_member_quota_percent = @@GLOBAL.group_replication_flow_control_member_quota_percent;
184 SET GLOBAL group_replication_flow_control_min_quota = @@GLOBAL.group_replication_flow_control_min_quota;
185 SET GLOBAL group_replication_flow_control_min_recovery_quota = @@GLOBAL.group_replication_flow_control_min_recovery_quota;
186 SET GLOBAL group_replication_flow_control_mode = @@GLOBAL.group_replication_flow_control_mode;
187 SET GLOBAL group_replication_flow_control_period = @@GLOBAL.group_replication_flow_control_period;
188 SET GLOBAL group_replication_flow_control_release_percent = @@GLOBAL.group_replication_flow_control_release_percent;
189 SET GLOBAL group_replication_force_members = @@GLOBAL.group_replication_force_members;
190 SET GLOBAL group_replication_group_name = @@GLOBAL.group_replication_group_name;
191 SET GLOBAL group_replication_group_seeds = @@GLOBAL.group_replication_group_seeds;
192 SET GLOBAL group_replication_gtid_assignment_block_size = @@GLOBAL.group_replication_gtid_assignment_block_size;
193 SET GLOBAL group_replication_ip_allowlist = @@GLOBAL.group_replication_ip_allowlist;
194 SET GLOBAL group_replication_ip_whitelist = @@GLOBAL.group_replication_ip_whitelist;
195 Warnings:
196 Warning 1287 'group_replication_ip_whitelist' is deprecated and will be removed in a future release. Please use group_replication_ip_allowlist instead
197 SET GLOBAL group_replication_local_address = @@GLOBAL.group_replication_local_address;
198 SET GLOBAL group_replication_member_expel_timeout = @@GLOBAL.group_replication_member_expel_timeout;
199 SET GLOBAL group_replication_member_weight = @@GLOBAL.group_replication_member_weight;
200 SET GLOBAL group_replication_message_cache_size = @@GLOBAL.group_replication_message_cache_size;
201 SET GLOBAL group_replication_paxos_single_leader = @@GLOBAL.group_replication_paxos_single_leader;
202 SET GLOBAL group_replication_poll_spin_loops = @@GLOBAL.group_replication_poll_spin_loops;
203 SET GLOBAL group_replication_recovery_complete_at = @@GLOBAL.group_replication_recovery_complete_at;
204 Warnings:
205 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
206 SET GLOBAL group_replication_recovery_compression_algorithms = @@GLOBAL.group_replication_recovery_compression_algorithms;
207 SET GLOBAL group_replication_recovery_get_public_key = @@GLOBAL.group_replication_recovery_get_public_key;
208 SET GLOBAL group_replication_recovery_public_key_path = @@GLOBAL.group_replication_recovery_public_key_path;
209 SET GLOBAL group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
210 SET GLOBAL group_replication_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
211 SET GLOBAL group_replication_recovery_ssl_ca = @@GLOBAL.group_replication_recovery_ssl_ca;
212 SET GLOBAL group_replication_recovery_ssl_capath = @@GLOBAL.group_replication_recovery_ssl_capath;
213 SET GLOBAL group_replication_recovery_ssl_cert = @@GLOBAL.group_replication_recovery_ssl_cert;
214 SET GLOBAL group_replication_recovery_ssl_cipher = @@GLOBAL.group_replication_recovery_ssl_cipher;
215 SET GLOBAL group_replication_recovery_ssl_crl = @@GLOBAL.group_replication_recovery_ssl_crl;
216 SET GLOBAL group_replication_recovery_ssl_crlpath = @@GLOBAL.group_replication_recovery_ssl_crlpath;
217 SET GLOBAL group_replication_recovery_ssl_key = @@GLOBAL.group_replication_recovery_ssl_key;
218 SET GLOBAL group_replication_recovery_ssl_verify_server_cert = @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;
219 SET GLOBAL group_replication_recovery_tls_ciphersuites = @@GLOBAL.group_replication_recovery_tls_ciphersuites;
220 SET GLOBAL group_replication_recovery_tls_version = @@GLOBAL.group_replication_recovery_tls_version;
221 SET GLOBAL group_replication_recovery_use_ssl = @@GLOBAL.group_replication_recovery_use_ssl;
222 SET GLOBAL group_replication_recovery_zstd_compression_level = @@GLOBAL.group_replication_recovery_zstd_compression_level;
223 SET GLOBAL group_replication_single_primary_mode = @@GLOBAL.group_replication_single_primary_mode;
224 SET GLOBAL group_replication_ssl_mode = @@GLOBAL.group_replication_ssl_mode;
225 SET GLOBAL group_replication_start_on_boot = @@GLOBAL.group_replication_start_on_boot;
226 SET GLOBAL group_replication_tls_source = @@GLOBAL.group_replication_tls_source;
227 SET GLOBAL group_replication_transaction_size_limit = @@GLOBAL.group_replication_transaction_size_limit;
228 SET GLOBAL group_replication_unreachable_majority_timeout = @@GLOBAL.group_replication_unreachable_majority_timeout;
229 SET GLOBAL group_replication_view_change_uuid = @@GLOBAL.group_replication_view_change_uuid;
230 Warnings:
231 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
232
233 ############################################################
234 # 4. Grant GROUP_REPLICATION_ADMIN and verify setting
235 # group_replication_consistency at global scope succeeds.
236 [connection server1]
237 GRANT GROUP_REPLICATION_ADMIN ON *.* TO 'no_priv_user'@localhost;
238 [connection no_priv_user_con]
239 SET GLOBAL group_replication_consistency = @@GLOBAL.group_replication_consistency;
240
241 ############################################################
242 # 5. Clean up.
243 [connection server1]
244 DROP TABLE gr_vars;
245 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'no_priv_user'@localhost;
246 DROP USER 'no_priv_user'@localhost;
247 FLUSH PRIVILEGES;
248 include/group_replication_end.inc