Debian Codegraph @

mysql-test/suite/connection_control/r/system_variables.result

raw
1 #-----------------------------------------------------------------------
2 # Setup
3 # Install connection_control plugin
4 INSTALL PLUGIN connection_control SONAME 'CONNECTION_CONTROL_LIB';
5 INSTALL PLUGIN connection_control_failed_login_attempts SONAME 'CONNECTION_CONTROL_LIB';
6 CREATE USER no_privs@localhost IDENTIFIED BY 'abcd';
7 #-----------------------------------------------------------------------
8 # Case 1 : connection_control_failed_connections_threshold
9 SHOW GRANTS;
10 Grants for root@localhost
11 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
12 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
13 GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION
14 SET @saved_value = @@global.connection_control_failed_connections_threshold;
15 SELECT @saved_value;
16 @saved_value
17 3
18 SET @@global.connection_control_failed_connections_threshold = @saved_value;
19 # 1.1 : Setting connection_control_failed_connections_threshold to valid
20 # value
21 SET @@global.connection_control_failed_connections_threshold = 20;
22 SELECT @@global.connection_control_failed_connections_threshold;
23 @@global.connection_control_failed_connections_threshold
24 20
25 SET @@global.connection_control_failed_connections_threshold = 2000;
26 SELECT @@global.connection_control_failed_connections_threshold;
27 @@global.connection_control_failed_connections_threshold
28 2000
29 SET @@global.connection_control_failed_connections_threshold = 2147483647;
30 SELECT @@global.connection_control_failed_connections_threshold;
31 @@global.connection_control_failed_connections_threshold
32 2147483647
33 SET @@global.connection_control_failed_connections_threshold = DEFAULT;
34 SELECT @@global.connection_control_failed_connections_threshold;
35 @@global.connection_control_failed_connections_threshold
36 3
37 # 1.2 : Setting connection_control_failed_connections_threshold to
38 # invalid value
39 SET @@global.connection_control_failed_connections_threshold = NULL;
40 ERROR 42000: Incorrect argument type to variable 'connection_control_failed_connections_threshold'
41 SELECT @@global.connection_control_failed_connections_threshold;
42 @@global.connection_control_failed_connections_threshold
43 3
44 SET @@global.connection_control_failed_connections_threshold = `SELECT * FROM mysql.user`;
45 ERROR 42000: Incorrect argument type to variable 'connection_control_failed_connections_threshold'
46 SELECT @@global.connection_control_failed_connections_threshold;
47 @@global.connection_control_failed_connections_threshold
48 3
49 SET @@global.connection_control_failed_connections_threshold = -20;
50 ERROR 42000: Variable 'connection_control_failed_connections_threshold' can't be set to the value of '-20'
51 SELECT @@global.connection_control_failed_connections_threshold;
52 @@global.connection_control_failed_connections_threshold
53 3
54 SET @@global.connection_control_failed_connections_threshold = 9223372036854775808;
55 ERROR 42000: Variable 'connection_control_failed_connections_threshold' can't be set to the value of '9223372036854775808'
56 SELECT @@global.connection_control_failed_connections_threshold;
57 @@global.connection_control_failed_connections_threshold
58 3
59 SET @@global.connection_control_failed_connections_threshold = -9223372036854775808;
60 ERROR 42000: Variable 'connection_control_failed_connections_threshold' can't be set to the value of '-9223372036854775808'
61 SELECT @@global.connection_control_failed_connections_threshold;
62 @@global.connection_control_failed_connections_threshold
63 3
64 # Switch to conn_no_privs
65 # 1.3 : Use no_privs@localhost to set
66 # connection_control_failed_connections_threshold to valid value
67 SET @@global.connection_control_failed_connections_threshold = 2147483647;
68 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
69 SELECT @@global.connection_control_failed_connections_threshold;
70 @@global.connection_control_failed_connections_threshold
71 3
72 SET @@global.connection_control_failed_connections_threshold = DEFAULT;
73 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
74 SELECT @@global.connection_control_failed_connections_threshold;
75 @@global.connection_control_failed_connections_threshold
76 3
77 # 1.4 : Use no_privs@localhost to set
78 # connection_control_failed_connections_threshold to invalid value
79 SET @@global.connection_control_failed_connections_threshold = NULL;
80 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
81 SELECT @@global.connection_control_failed_connections_threshold;
82 @@global.connection_control_failed_connections_threshold
83 3
84 SET @@global.connection_control_failed_connections_threshold = 9223372036854775808;
85 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
86 SELECT @@global.connection_control_failed_connections_threshold;
87 @@global.connection_control_failed_connections_threshold
88 3
89 SET @@global.connection_control_failed_connections_threshold = @saved_value;
90 SELECT @@global.connection_control_failed_connections_threshold;
91 @@global.connection_control_failed_connections_threshold
92 3
93 #-----------------------------------------------------------------------
94 # Case 2 : connection_control_min_connection_delay
95 SET @saved_value= @@global.connection_control_min_connection_delay;
96 SELECT @saved_value;
97 @saved_value
98 1000
99 # 2.1 : Setting connection_control_min_connection_delay to valid
100 # value
101 SET @@global.connection_control_min_connection_delay = 20000;
102 SELECT @@global.connection_control_min_connection_delay;
103 @@global.connection_control_min_connection_delay
104 20000
105 SET @@global.connection_control_min_connection_delay = 2000;
106 SELECT @@global.connection_control_min_connection_delay;
107 @@global.connection_control_min_connection_delay
108 2000
109 SET @@global.connection_control_min_connection_delay = 2147483647;
110 SELECT @@global.connection_control_min_connection_delay;
111 @@global.connection_control_min_connection_delay
112 2147483647
113 SET @@global.connection_control_min_connection_delay = DEFAULT;
114 SELECT @@global.connection_control_min_connection_delay;
115 @@global.connection_control_min_connection_delay
116 1000
117 # 2.2 : Setting connection_control_min_connection_delay to
118 # invalid value
119 SET @@global.connection_control_min_connection_delay = NULL;
120 ERROR 42000: Incorrect argument type to variable 'connection_control_min_connection_delay'
121 SELECT @@global.connection_control_min_connection_delay;
122 @@global.connection_control_min_connection_delay
123 1000
124 SET @@global.connection_control_min_connection_delay = `SELECT * FROM mysql.user`;
125 ERROR 42000: Incorrect argument type to variable 'connection_control_min_connection_delay'
126 SELECT @@global.connection_control_min_connection_delay;
127 @@global.connection_control_min_connection_delay
128 1000
129 SET @@global.connection_control_min_connection_delay = -20;
130 ERROR 42000: Variable 'connection_control_min_connection_delay' can't be set to the value of '-20'
131 SELECT @@global.connection_control_min_connection_delay;
132 @@global.connection_control_min_connection_delay
133 1000
134 SET @@global.connection_control_min_connection_delay = 9223372036854775808;
135 ERROR 42000: Variable 'connection_control_min_connection_delay' can't be set to the value of '9223372036854775808'
136 SELECT @@global.connection_control_min_connection_delay;
137 @@global.connection_control_min_connection_delay
138 1000
139 SET @@global.connection_control_min_connection_delay = -9223372036854775808;
140 ERROR 42000: Variable 'connection_control_min_connection_delay' can't be set to the value of '-9223372036854775808'
141 SELECT @@global.connection_control_min_connection_delay;
142 @@global.connection_control_min_connection_delay
143 1000
144 SET@@global.connection_control_min_connection_delay = 20;
145 ERROR 42000: Variable 'connection_control_min_connection_delay' can't be set to the value of '20'
146 SELECT @@global.connection_control_min_connection_delay;
147 @@global.connection_control_min_connection_delay
148 1000
149 # Switch to conn_no_privs
150 # 2.3 : Use no_privs@localhost to set
151 # connection_control_min_connection_delay to valid value
152 SET @@global.connection_control_min_connection_delay = 2147483647;
153 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
154 SELECT @@global.connection_control_min_connection_delay;
155 @@global.connection_control_min_connection_delay
156 1000
157 SET @@global.connection_control_min_connection_delay = DEFAULT;
158 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
159 SELECT @@global.connection_control_min_connection_delay;
160 @@global.connection_control_min_connection_delay
161 1000
162 # 2.4 : Use no_privs@localhost to set
163 # connection_control_min_connection_delay to invalid value
164 SET @@global.connection_control_min_connection_delay = NULL;
165 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
166 SELECT @@global.connection_control_min_connection_delay;
167 @@global.connection_control_min_connection_delay
168 1000
169 SET @@global.connection_control_min_connection_delay = 9223372036854775808;
170 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
171 SELECT @@global.connection_control_min_connection_delay;
172 @@global.connection_control_min_connection_delay
173 1000
174 # Switch to default connection
175 # 2.5 : Setting connection_control_min_connection_delay to a value
176 # greater than connection_control_max_connection_delay
177 SET @saved_max_delay= @@global.connection_control_max_connection_delay;
178 SET @@global.connection_control_max_connection_delay= 10000;
179 SET @@global.connection_control_min_connection_delay= 11000;
180 ERROR 42000: Variable 'connection_control_min_connection_delay' can't be set to the value of '11000'
181 SELECT @@global.connection_control_min_connection_delay;
182 @@global.connection_control_min_connection_delay
183 1000
184 SET @@global.connection_control_max_connection_delay= @saved_max_delay;
185 SET @@global.connection_control_min_connection_delay = @saved_value;
186 SELECT @@global.connection_control_min_connection_delay;
187 @@global.connection_control_min_connection_delay
188 1000
189 #-----------------------------------------------------------------------
190 # Case 3 : connection_control_max_connection_delay
191 SET @saved_value= @@global.connection_control_max_connection_delay;
192 SELECT @saved_value;
193 @saved_value
194 2147483647
195 # 3.1 : Setting connection_control_max_connection_delay to valid
196 # value
197 SET @@global.connection_control_max_connection_delay = 20000;
198 SELECT @@global.connection_control_max_connection_delay;
199 @@global.connection_control_max_connection_delay
200 20000
201 SET @@global.connection_control_max_connection_delay = 2000;
202 SELECT @@global.connection_control_max_connection_delay;
203 @@global.connection_control_max_connection_delay
204 2000
205 SET @@global.connection_control_max_connection_delay = 2147483647;
206 SELECT @@global.connection_control_max_connection_delay;
207 @@global.connection_control_max_connection_delay
208 2147483647
209 SET @@global.connection_control_max_connection_delay = DEFAULT;
210 SELECT @@global.connection_control_max_connection_delay;
211 @@global.connection_control_max_connection_delay
212 2147483647
213 # 3.2 : Setting connection_control_max_connection_delay to
214 # invalid value
215 SET @@global.connection_control_max_connection_delay = NULL;
216 ERROR 42000: Incorrect argument type to variable 'connection_control_max_connection_delay'
217 SELECT @@global.connection_control_max_connection_delay;
218 @@global.connection_control_max_connection_delay
219 2147483647
220 SET @@global.connection_control_max_connection_delay = `SELECT * FROM mysql.user`;
221 ERROR 42000: Incorrect argument type to variable 'connection_control_max_connection_delay'
222 SELECT @@global.connection_control_max_connection_delay;
223 @@global.connection_control_max_connection_delay
224 2147483647
225 SET @@global.connection_control_max_connection_delay = -20;
226 ERROR 42000: Variable 'connection_control_max_connection_delay' can't be set to the value of '-20'
227 SELECT @@global.connection_control_max_connection_delay;
228 @@global.connection_control_max_connection_delay
229 2147483647
230 SET @@global.connection_control_max_connection_delay = 9223372036854775808;
231 ERROR 42000: Variable 'connection_control_max_connection_delay' can't be set to the value of '9223372036854775808'
232 SELECT @@global.connection_control_max_connection_delay;
233 @@global.connection_control_max_connection_delay
234 2147483647
235 SET @@global.connection_control_max_connection_delay = -9223372036854775808;
236 ERROR 42000: Variable 'connection_control_max_connection_delay' can't be set to the value of '-9223372036854775808'
237 SELECT @@global.connection_control_max_connection_delay;
238 @@global.connection_control_max_connection_delay
239 2147483647
240 SET @@global.connection_control_max_connection_delay = 20;
241 ERROR 42000: Variable 'connection_control_max_connection_delay' can't be set to the value of '20'
242 SELECT @@global.connection_control_max_connection_delay;
243 @@global.connection_control_max_connection_delay
244 2147483647
245 # Switch to conn_no_privs
246 # 3.3 : Use no_privs@localhost to set
247 # connection_control_max_connection_delay to valid value
248 SET @@global.connection_control_max_connection_delay = 2147483647;
249 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
250 SELECT @@global.connection_control_max_connection_delay;
251 @@global.connection_control_max_connection_delay
252 2147483647
253 SET @@global.connection_control_max_connection_delay = DEFAULT;
254 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
255 SELECT @@global.connection_control_max_connection_delay;
256 @@global.connection_control_max_connection_delay
257 2147483647
258 # 3.4 : Use no_privs@localhost to set
259 # connection_control_max_connection_delay to invalid value
260 SET @@global.connection_control_max_connection_delay = NULL;
261 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
262 SELECT @@global.connection_control_max_connection_delay;
263 @@global.connection_control_max_connection_delay
264 2147483647
265 SET @@global.connection_control_max_connection_delay = 9223372036854775808;
266 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
267 SELECT @@global.connection_control_max_connection_delay;
268 @@global.connection_control_max_connection_delay
269 2147483647
270 # Switch to default connection
271 # 3.5 : Setting connection_control_min_connection_delay to a value
272 # greater than connection_control_max_connection_delay
273 SET @saved_min_delay= @@global.connection_control_min_connection_delay;
274 SET @@global.connection_control_min_connection_delay= 11000;
275 SET @@global.connection_control_max_connection_delay= 10000;
276 ERROR 42000: Variable 'connection_control_max_connection_delay' can't be set to the value of '10000'
277 SELECT @@global.connection_control_max_connection_delay;
278 @@global.connection_control_max_connection_delay
279 2147483647
280 SET @@global.connection_control_min_connection_delay= @saved_min_delay;
281 SET @@global.connection_control_max_connection_delay = @saved_value;
282 SELECT @@global.connection_control_max_connection_delay;
283 @@global.connection_control_max_connection_delay
284 2147483647
285 # Test setting connection_control_exempt_unknown_users to invalid values
286 SET @saved_exempt= @@global.connection_control_exempt_unknown_users;
287 SELECT @@global.connection_control_exempt_unknown_users;
288 @@global.connection_control_exempt_unknown_users
289 0
290 SET @@global.connection_control_exempt_unknown_users= -1;
291 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of '-1'
292 SELECT @@global.connection_control_exempt_unknown_users;
293 @@global.connection_control_exempt_unknown_users
294 0
295 SET @@global.connection_control_exempt_unknown_users= 7;
296 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of '7'
297 SELECT @@global.connection_control_exempt_unknown_users;
298 @@global.connection_control_exempt_unknown_users
299 0
300 SET @@global.connection_control_exempt_unknown_users= "YESS";
301 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'YESS'
302 SELECT @@global.connection_control_exempt_unknown_users;
303 @@global.connection_control_exempt_unknown_users
304 0
305 SET @@global.connection_control_exempt_unknown_users= "ye";
306 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'ye'
307 SELECT @@global.connection_control_exempt_unknown_users;
308 @@global.connection_control_exempt_unknown_users
309 0
310 SET @@global.connection_control_exempt_unknown_users= "NOOOOO";
311 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'NOOOOO'
312 SELECT @@global.connection_control_exempt_unknown_users;
313 @@global.connection_control_exempt_unknown_users
314 0
315 SET @@global.connection_control_exempt_unknown_users= "n";
316 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'n'
317 SELECT @@global.connection_control_exempt_unknown_users;
318 @@global.connection_control_exempt_unknown_users
319 0
320 SET @@global.connection_control_exempt_unknown_users= "ONN";
321 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'ONN'
322 SELECT @@global.connection_control_exempt_unknown_users;
323 @@global.connection_control_exempt_unknown_users
324 0
325 SET @@global.connection_control_exempt_unknown_users= "offf";
326 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'offf'
327 SELECT @@global.connection_control_exempt_unknown_users;
328 @@global.connection_control_exempt_unknown_users
329 0
330 SET @@global.connection_control_exempt_unknown_users= "NO";
331 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'NO'
332 SELECT @@global.connection_control_exempt_unknown_users;
333 @@global.connection_control_exempt_unknown_users
334 0
335 SET @@global.connection_control_exempt_unknown_users= NO;
336 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'NO'
337 SELECT @@global.connection_control_exempt_unknown_users;
338 @@global.connection_control_exempt_unknown_users
339 0
340 SET @@global.connection_control_exempt_unknown_users= "YES";
341 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'YES'
342 SELECT @@global.connection_control_exempt_unknown_users;
343 @@global.connection_control_exempt_unknown_users
344 0
345 SET @@global.connection_control_exempt_unknown_users= YES;
346 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'YES'
347 SELECT @@global.connection_control_exempt_unknown_users;
348 @@global.connection_control_exempt_unknown_users
349 0
350 SET @@global.connection_control_exempt_unknown_users= "no";
351 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'no'
352 SELECT @@global.connection_control_exempt_unknown_users;
353 @@global.connection_control_exempt_unknown_users
354 0
355 SET @@global.connection_control_exempt_unknown_users= "yes";
356 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'yes'
357 SELECT @@global.connection_control_exempt_unknown_users;
358 @@global.connection_control_exempt_unknown_users
359 0
360 SET @@global.connection_control_exempt_unknown_users= "FALSE";
361 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'FALSE'
362 SELECT @@global.connection_control_exempt_unknown_users;
363 @@global.connection_control_exempt_unknown_users
364 0
365 SET @@global.connection_control_exempt_unknown_users= "TRUE";
366 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'TRUE'
367 SELECT @@global.connection_control_exempt_unknown_users;
368 @@global.connection_control_exempt_unknown_users
369 0
370 SET @@global.connection_control_exempt_unknown_users= "false";
371 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'false'
372 SELECT @@global.connection_control_exempt_unknown_users;
373 @@global.connection_control_exempt_unknown_users
374 0
375 SET @@global.connection_control_exempt_unknown_users= "true";
376 ERROR 42000: Variable 'connection_control_exempt_unknown_users' can't be set to the value of 'true'
377 SELECT @@global.connection_control_exempt_unknown_users;
378 @@global.connection_control_exempt_unknown_users
379 0
380 # Test setting connection_control_exempt_unknown_users to valid values
381 SET @@global.connection_control_exempt_unknown_users= 0;
382 SELECT @@global.connection_control_exempt_unknown_users;
383 @@global.connection_control_exempt_unknown_users
384 0
385 SET @@global.connection_control_exempt_unknown_users= 1;
386 SELECT @@global.connection_control_exempt_unknown_users;
387 @@global.connection_control_exempt_unknown_users
388 1
389 SET @@global.connection_control_exempt_unknown_users= "OFF";
390 SELECT @@global.connection_control_exempt_unknown_users;
391 @@global.connection_control_exempt_unknown_users
392 0
393 SET @@global.connection_control_exempt_unknown_users= "ON";
394 SELECT @@global.connection_control_exempt_unknown_users;
395 @@global.connection_control_exempt_unknown_users
396 1
397 SET @@global.connection_control_exempt_unknown_users= FALSE;
398 SELECT @@global.connection_control_exempt_unknown_users;
399 @@global.connection_control_exempt_unknown_users
400 0
401 SET @@global.connection_control_exempt_unknown_users= TRUE;
402 SELECT @@global.connection_control_exempt_unknown_users;
403 @@global.connection_control_exempt_unknown_users
404 1
405 SET @@global.connection_control_exempt_unknown_users= "off";
406 SELECT @@global.connection_control_exempt_unknown_users;
407 @@global.connection_control_exempt_unknown_users
408 0
409 SET @@global.connection_control_exempt_unknown_users= "on";
410 SELECT @@global.connection_control_exempt_unknown_users;
411 @@global.connection_control_exempt_unknown_users
412 1
413 SET @@global.connection_control_exempt_unknown_users= false;
414 SELECT @@global.connection_control_exempt_unknown_users;
415 @@global.connection_control_exempt_unknown_users
416 0
417 SET @@global.connection_control_exempt_unknown_users= true;
418 SELECT @@global.connection_control_exempt_unknown_users;
419 @@global.connection_control_exempt_unknown_users
420 1
421 SET @@global.connection_control_exempt_unknown_users= @saved_exempt;
422 #-----------------------------------------------------------------------
423 # Cleanup
424 DROP USER no_privs@localhost;
425 # Uninstall connection_control plugin
426 UNINSTALL PLUGIN connection_control;
427 UNINSTALL PLUGIN connection_control_failed_login_attempts;
428 #-----------------------------------------------------------------------