Debian Codegraph @

mysql-test/suite/binlog/r/binlog_grant_alter_user.result

raw
1 include/master-slave.inc
2 Warnings:
3 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.
4 [connection master]
5 #
6 # WL#6409: CREATE/ALTER USER
7 #
8 # CREATE USER
9
10 CREATE USER user1;
11 SELECT host,user,plugin
12 FROM mysql.user WHERE user = 'user1';
13 host %
14 user user1
15 plugin caching_sha2_password
16
17 CREATE USER user3@%;
18 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' at line 1
19 CREATE USER user3@localhost BY 'auth_string' WITH 'mysql_native_password';
20 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY 'auth_string' WITH 'mysql_native_password'' at line 1
21 CREATE USER "user2"@'%';
22 SELECT host,user,plugin
23 FROM mysql.user WHERE user='user2';
24 host %
25 user user2
26 plugin caching_sha2_password
27
28 CREATE USER u1@localhost;
29 SELECT user,plugin FROM mysql.user WHERE USER='u1';
30 user u1
31 plugin caching_sha2_password
32 CREATE USER u2@localhost IDENTIFIED BY 'auth_string' ACCOUNT LOCK;
33 SELECT user,plugin FROM mysql.user WHERE USER='u2';
34 user u2
35 plugin caching_sha2_password
36
37 CREATE USER user5@localhost IDENTIFIED AS 'auth_string';
38 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS 'auth_string'' at line 1
39 CREATE USER u3@localhost IDENTIFIED WITH 'mysql_native_password';
40 SELECT user,plugin FROM mysql.user WHERE USER='u3';
41 user u3
42 plugin mysql_native_password
43 CREATE USER u4@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
44 SELECT user,plugin FROM mysql.user WHERE USER='u4';
45 user u4
46 plugin mysql_native_password
47 SELECT USER();
48 USER()
49 u4@localhost
50
51 CREATE USER user4@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
52 SELECT user,plugin FROM mysql.user WHERE USER='user4';
53 user user4
54 plugin mysql_native_password
55
56 CREATE USER user6@localhost IDENTIFIED WITH 'mysql_native_password';
57 SELECT user,plugin FROM mysql.user WHERE USER='user6';
58 user user6
59 plugin mysql_native_password
60
61 CREATE USER user7@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string#%y'
62 PASSWORD EXPIRE NEVER ACCOUNT UNLOCK;
63 SELECT user,plugin FROM mysql.user WHERE USER='user7';
64 user user7
65 plugin mysql_native_password
66
67 SELECT USER();
68 USER()
69 user7@localhost
70 CREATE USER user8@localhost IDENTIFIED WITH 'mysql_native_password'
71 AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF';
72 SELECT user,plugin FROM mysql.user WHERE USER='user8';
73 user user8
74 plugin mysql_native_password
75 SELECT USER();
76 USER()
77 user8@localhost
78 CREATE USER tu1@localhost IDENTIFIED WITH 'mysql_native_password';
79 SELECT user,plugin,password_expired,
80 password_expired FROM mysql.user WHERE USER='tu1';
81 user tu1
82 plugin mysql_native_password
83 password_expired N
84 password_expired N
85 CREATE USER tu2@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_@13*';
86 SELECT user,plugin,
87 password_expired FROM mysql.user WHERE USER='tu2';
88 user tu2
89 plugin mysql_native_password
90 password_expired N
91
92 CREATE USER tu3@localhost IDENTIFIED WITH 'mysql_native_password' BY '%auth_O0s-tring';
93 SELECT user,plugin,password_expired
94 FROM mysql.user WHERE USER='tu3';
95 user tu3
96 plugin mysql_native_password
97 password_expired N
98
99 CREATE USER u5@localhost REQUIRE SSL;
100 SELECT user,plugin,ssl_type
101 FROM mysql.user WHERE USER='u5';
102 user u5
103 plugin caching_sha2_password
104 ssl_type ANY
105 CREATE USER u6@localhost IDENTIFIED BY 'auth_string' REQUIRE X509;
106 SELECT user,plugin,ssl_type
107 FROM mysql.user WHERE USER='u6';
108 user u6
109 plugin caching_sha2_password
110 ssl_type X509
111 CREATE USER tu4@localhost IDENTIFIED WITH 'mysql_native_password' BY 'djgsj743$' REQUIRE SSL;
112 SELECT user,plugin,ssl_type FROM mysql.user WHERE USER='tu4';
113 user tu4
114 plugin mysql_native_password
115 ssl_type ANY
116 CREATE USER tu5@localhost IDENTIFIED WITH 'mysql_native_password' BY 'dwh@#ghd$!' REQUIRE X509;
117 SELECT user,plugin,ssl_type FROM mysql.user WHERE USER='tu5';
118 user tu5
119 plugin mysql_native_password
120 ssl_type X509
121 CREATE USER u7@localhost IDENTIFIED WITH 'mysql_native_password'
122 REQUIRE CIPHER 'cipher';
123 SELECT user,plugin,ssl_type,ssl_cipher,
124 x509_issuer,x509_subject FROM mysql.user WHERE USER='u7';
125 user u7
126 plugin mysql_native_password
127 ssl_type SPECIFIED
128 ssl_cipher cipher
129 x509_issuer
130 x509_subject
131 CREATE USER u8@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
132 REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA';
133 SELECT user,plugin,ssl_type,ssl_cipher,
134 x509_issuer,x509_subject FROM mysql.user WHERE USER='u8';
135 user u8
136 plugin mysql_native_password
137 ssl_type SPECIFIED
138 ssl_cipher
139 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
140 x509_subject
141 CREATE USER u9@localhost REQUIRE SUBJECT 'sub';
142 SELECT user,plugin,ssl_type,ssl_cipher,
143 x509_issuer,x509_subject FROM mysql.user WHERE USER='u9';
144 user u9
145 plugin caching_sha2_password
146 ssl_type SPECIFIED
147 ssl_cipher
148 x509_issuer
149 x509_subject sub
150 CREATE USER u10@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string#y'
151 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
152 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
153 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA";
154 SELECT user,plugin,ssl_type,ssl_cipher,
155 x509_issuer,x509_subject FROM mysql.user WHERE USER='u10';
156 user u10
157 plugin mysql_native_password
158 ssl_type SPECIFIED
159 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
160 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
161 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
162 SELECT USER();
163 USER()
164 u10@localhost
165 CREATE USER tu6@localhost IDENTIFIED WITH 'mysql_native_password' BY '#hGrt0O6'
166 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
167 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
168 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
169 WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2;
170 SELECT user,plugin,ssl_type,ssl_cipher,x509_issuer,
171 x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='tu6';
172 user tu6
173 plugin mysql_native_password
174 ssl_type SPECIFIED
175 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
176 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
177 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
178 max_questions 2
179 max_user_connections 2
180 CREATE USER u11@localhost WITH MAX_QUERIES_PER_HOUR 2;
181 SELECT user,plugin,max_questions
182 FROM mysql.user WHERE USER='u11';
183 user u11
184 plugin caching_sha2_password
185 max_questions 2
186 CREATE USER u12@localhost IDENTIFIED BY 'auth_string' WITH MAX_QUERIES_PER_HOUR 2;
187 SELECT user,plugin,max_questions
188 FROM mysql.user WHERE USER='u12';
189 user u12
190 plugin caching_sha2_password
191 max_questions 2
192 CREATE USER u13@localhost IDENTIFIED WITH 'mysql_native_password'
193 WITH MAX_CONNECTIONS_PER_HOUR 2;
194 SELECT user,plugin,max_connections
195 FROM mysql.user WHERE USER='u13';
196 user u13
197 plugin mysql_native_password
198 max_connections 2
199 CREATE USER u14@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
200 WITH MAX_USER_CONNECTIONS 2 ACCOUNT LOCK;
201 SELECT user,plugin,max_user_connections
202 FROM mysql.user WHERE USER='u14';
203 user u14
204 plugin mysql_native_password
205 max_user_connections 2
206 CREATE USER u15@localhost,
207 u16@localhost IDENTIFIED BY 'auth_string',
208 u17@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
209 SELECT user,plugin FROM mysql.user WHERE USER='u15';
210 user u15
211 plugin caching_sha2_password
212 SELECT user,plugin FROM mysql.user WHERE USER='u16';
213 user u16
214 plugin caching_sha2_password
215 SELECT user,plugin FROM mysql.user WHERE USER='u17';
216 user u17
217 plugin mysql_native_password
218 CREATE USER u18@localhost,
219 u19@localhost IDENTIFIED BY 'auth_string',
220 u20@localhost IDENTIFIED WITH 'mysql_native_password',
221 u21@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string',
222 u22@localhost IDENTIFIED WITH 'mysql_native_password',
223 u23@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_&string'
224 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
225 WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2 ACCOUNT UNLOCK;
226 SELECT user,plugin,ssl_type,ssl_cipher,
227 x509_issuer,x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='u18';
228 user u18
229 plugin caching_sha2_password
230 ssl_type SPECIFIED
231 ssl_cipher
232 x509_issuer
233 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
234 max_questions 2
235 max_user_connections 2
236 SELECT user,plugin,ssl_type,ssl_cipher,
237 x509_issuer,x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='u19';
238 user u19
239 plugin caching_sha2_password
240 ssl_type SPECIFIED
241 ssl_cipher
242 x509_issuer
243 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
244 max_questions 2
245 max_user_connections 2
246 SELECT user,plugin,ssl_type,ssl_cipher,
247 x509_issuer,x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='u20';
248 user u20
249 plugin mysql_native_password
250 ssl_type SPECIFIED
251 ssl_cipher
252 x509_issuer
253 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
254 max_questions 2
255 max_user_connections 2
256 SELECT user,plugin,ssl_type,ssl_cipher,
257 x509_issuer,x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='u22';
258 user u22
259 plugin mysql_native_password
260 ssl_type SPECIFIED
261 ssl_cipher
262 x509_issuer
263 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
264 max_questions 2
265 max_user_connections 2
266 SELECT user,plugin,ssl_type,ssl_cipher,
267 x509_issuer,x509_subject,max_questions,max_user_connections FROM mysql.user WHERE USER='u23';
268 user u23
269 plugin mysql_native_password
270 ssl_type SPECIFIED
271 ssl_cipher
272 x509_issuer
273 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
274 max_questions 2
275 max_user_connections 2
276 DROP USER tu1@localhost,tu2@localhost,tu3@localhost,tu4@localhost,tu5@localhost,
277 tu6@localhost,user1@'%',user2@'%',user4@localhost,user6@localhost,
278 user7@localhost,user8@localhost, u1@localhost,u2@localhost,u3@localhost,
279 u4@localhost,u5@localhost,u6@localhost, u7@localhost, u8@localhost,
280 u9@localhost, u10@localhost,u11@localhost, u12@localhost,u13@localhost,
281 u14@localhost,u15@localhost,u16@localhost,u17@localhost,u18@localhost,
282 u19@localhost, u20@localhost,u21@localhost,u22@localhost,u23@localhost;
283 # ALTER USER
284 CREATE USER u1@localhost;
285 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
286 plugin,password_expired,
287 password_last_changed,password_lifetime
288 FROM mysql.user WHERE USER='u1';
289 user u1
290 ssl_type
291 ssl_cipher
292 x509_issuer
293 x509_subject
294 plugin caching_sha2_password
295 password_expired N
296 password_last_changed #
297 password_lifetime NULL
298 # Its a no op
299 ALTER USER u1@localhost;
300 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
301 plugin,password_expired,
302 password_last_changed,password_lifetime
303 FROM mysql.user WHERE USER='u1';
304 user u1
305 ssl_type
306 ssl_cipher
307 x509_issuer
308 x509_subject
309 plugin caching_sha2_password
310 password_expired N
311 password_last_changed #
312 password_lifetime NULL
313 CREATE USER u2@localhost IDENTIFIED BY 'password_string';
314 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
315 plugin,password_expired,
316 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u2';
317 user u2
318 ssl_type
319 ssl_cipher
320 x509_issuer
321 x509_subject
322 plugin caching_sha2_password
323 password_expired N
324 password_last_changed #
325 password_lifetime NULL
326 ALTER USER u2@localhost IDENTIFIED BY 'new_auth_string';
327 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
328 plugin,password_expired,
329 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u2';
330 user u2
331 ssl_type
332 ssl_cipher
333 x509_issuer
334 x509_subject
335 plugin caching_sha2_password
336 password_expired N
337 password_last_changed #
338 password_lifetime NULL
339 SELECT USER();
340 USER()
341 u2@localhost
342
343 CREATE USER u3@localhost IDENTIFIED WITH 'mysql_native_password' ACCOUNT LOCK;
344 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
345 plugin,password_expired,
346 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u3';
347 user u3
348 ssl_type
349 ssl_cipher
350 x509_issuer
351 x509_subject
352 plugin mysql_native_password
353 password_expired N
354 password_last_changed #
355 password_lifetime NULL
356 ALTER USER u3@localhost IDENTIFIED WITH 'mysql_native_password'
357 AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
358 PASSWORD EXPIRE NEVER ACCOUNT UNLOCK;
359 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
360 plugin,password_expired,
361 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u3';
362 user u3
363 ssl_type
364 ssl_cipher
365 x509_issuer
366 x509_subject
367 plugin mysql_native_password
368 password_expired N
369 password_last_changed #
370 password_lifetime 0
371 SELECT USER();
372 USER()
373 u3@localhost
374 ALTER USER u3@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
375 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
376 plugin,password_expired,
377 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u3';
378 user u3
379 ssl_type
380 ssl_cipher
381 x509_issuer
382 x509_subject
383 plugin mysql_native_password
384 password_expired N
385 password_last_changed #
386 password_lifetime 0
387 ALTER USER u3@localhost
388 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
389 WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2
390 PASSWORD EXPIRE NEVER;
391 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
392 plugin,password_expired,
393 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u3';
394 user u3
395 ssl_type SPECIFIED
396 ssl_cipher
397 x509_issuer
398 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
399 plugin mysql_native_password
400 password_expired N
401 password_last_changed #
402 password_lifetime 0
403 CREATE USER u4@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
404 ACCOUNT LOCK PASSWORD EXPIRE DEFAULT;
405 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
406 plugin,password_expired,
407 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u4';
408 user u4
409 ssl_type
410 ssl_cipher
411 x509_issuer
412 x509_subject
413 plugin mysql_native_password
414 password_expired N
415 password_last_changed #
416 password_lifetime NULL
417 ALTER USER u4@localhost IDENTIFIED WITH 'mysql_native_password'
418 BY 'auth_string' ACCOUNT UNLOCK;
419 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
420 plugin,password_expired,
421 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u4';
422 user u4
423 ssl_type
424 ssl_cipher
425 x509_issuer
426 x509_subject
427 plugin mysql_native_password
428 password_expired N
429 password_last_changed #
430 password_lifetime NULL
431 CREATE USER u5@localhost REQUIRE SSL;
432 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
433 plugin,password_expired,
434 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u5';
435 user u5
436 ssl_type ANY
437 ssl_cipher
438 x509_issuer
439 x509_subject
440 plugin caching_sha2_password
441 password_expired N
442 password_last_changed #
443 password_lifetime NULL
444 ALTER USER u5@localhost IDENTIFIED WITH 'mysql_native_password';
445 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
446 plugin,password_expired,
447 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u5';
448 user u5
449 ssl_type ANY
450 ssl_cipher
451 x509_issuer
452 x509_subject
453 plugin mysql_native_password
454 password_expired Y
455 password_last_changed #
456 password_lifetime NULL
457 SET PASSWORD='new_auth_string';
458 SELECT USER();
459 USER()
460 u5@localhost
461 CREATE USER u6@localhost IDENTIFIED BY 'auth_string' REQUIRE X509 ACCOUNT UNLOCK ACCOUNT LOCK PASSWORD EXPIRE INTERVAL 80 DAY;
462 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
463 plugin,password_expired,
464 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u6';
465 user u6
466 ssl_type X509
467 ssl_cipher
468 x509_issuer
469 x509_subject
470 plugin caching_sha2_password
471 password_expired N
472 password_last_changed #
473 password_lifetime 80
474 ALTER USER u6@localhost IDENTIFIED WITH 'mysql_native_password' BY 'new_auth_string' REQUIRE SSL ACCOUNT UNLOCK;
475 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
476 plugin,password_expired,
477 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u6';
478 user u6
479 ssl_type ANY
480 ssl_cipher
481 x509_issuer
482 x509_subject
483 plugin mysql_native_password
484 password_expired N
485 password_last_changed #
486 password_lifetime 80
487 CREATE USER u7@localhost IDENTIFIED WITH 'mysql_native_password'
488 BY 'auth_string' REQUIRE CIPHER 'ECDHE-RSA-AES128-GCM-SHA256';
489 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
490 plugin,password_expired,
491 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u7';
492 user u7
493 ssl_type SPECIFIED
494 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
495 x509_issuer
496 x509_subject
497 plugin mysql_native_password
498 password_expired N
499 password_last_changed #
500 password_lifetime NULL
501 ALTER USER u7@localhost IDENTIFIED WITH 'mysql_native_password' BY 'new_auth_string'
502 REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' ACCOUNT UNLOCK;
503 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
504 plugin,password_expired,
505 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u7';
506 user u7
507 ssl_type SPECIFIED
508 ssl_cipher
509 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
510 x509_subject
511 plugin mysql_native_password
512 password_expired N
513 password_last_changed #
514 password_lifetime NULL
515 SELECT USER();
516 USER()
517 u7@localhost
518 CREATE USER u8@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
519 REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA';
520 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
521 plugin,password_expired,
522 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u8';
523 user u8
524 ssl_type SPECIFIED
525 ssl_cipher
526 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
527 x509_subject
528 plugin mysql_native_password
529 password_expired N
530 password_last_changed #
531 password_lifetime NULL
532 ALTER USER u8@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
533 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256";
534 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
535 plugin,password_expired,
536 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u8';
537 user u8
538 ssl_type SPECIFIED
539 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
540 x509_issuer
541 x509_subject
542 plugin mysql_native_password
543 password_expired N
544 password_last_changed #
545 password_lifetime NULL
546 SELECT USER();
547 USER()
548 u8@localhost
549 CREATE USER tu1@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
550 REQUIRE ISSUER 'issuer';
551 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
552 plugin,password_expired,
553 password_last_changed,password_lifetime FROM mysql.user WHERE USER='tu1';
554 user tu1
555 ssl_type SPECIFIED
556 ssl_cipher
557 x509_issuer issuer
558 x509_subject
559 plugin mysql_native_password
560 password_expired N
561 password_last_changed #
562 password_lifetime NULL
563 ALTER USER tu1@localhost IDENTIFIED WITH 'mysql_native_password'
564 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256";
565 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
566 plugin,password_expired,
567 password_last_changed,password_lifetime FROM mysql.user WHERE USER='tu1';
568 user tu1
569 ssl_type SPECIFIED
570 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
571 x509_issuer
572 x509_subject
573 plugin mysql_native_password
574 password_expired Y
575 password_last_changed #
576 password_lifetime NULL
577 CREATE USER u9@localhost REQUIRE SUBJECT 'sub';
578 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
579 plugin,password_expired,
580 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u9';
581 user u9
582 ssl_type SPECIFIED
583 ssl_cipher
584 x509_issuer
585 x509_subject sub
586 plugin caching_sha2_password
587 password_expired N
588 password_last_changed #
589 password_lifetime NULL
590 ALTER USER u9@localhost REQUIRE ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA";
591 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
592 plugin,password_expired,
593 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u9';
594 user u9
595 ssl_type SPECIFIED
596 ssl_cipher
597 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
598 x509_subject
599 plugin caching_sha2_password
600 password_expired N
601 password_last_changed #
602 password_lifetime NULL
603 ALTER USER u9@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string77hg'
604 REQUIRE ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA";
605 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
606 plugin,password_expired,
607 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u9';
608 user u9
609 ssl_type SPECIFIED
610 ssl_cipher
611 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
612 x509_subject
613 plugin mysql_native_password
614 password_expired N
615 password_last_changed #
616 password_lifetime NULL
617 CREATE USER u10@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
618 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
619 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
620 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA";
621 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
622 plugin,password_expired,
623 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u10';
624 user u10
625 ssl_type SPECIFIED
626 ssl_cipher ECDHE-RSA-AES128-GCM-SHA256
627 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
628 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
629 plugin mysql_native_password
630 password_expired N
631 password_last_changed #
632 password_lifetime NULL
633 ALTER USER u10@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
634 REQUIRE SSL;
635 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
636 plugin,password_expired,
637 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u10';
638 user u10
639 ssl_type ANY
640 ssl_cipher
641 x509_issuer
642 x509_subject
643 plugin mysql_native_password
644 password_expired N
645 password_last_changed #
646 password_lifetime NULL
647 SELECT USER();
648 USER()
649 u10@localhost
650 CREATE USER u11@localhost WITH MAX_QUERIES_PER_HOUR 2;
651 SELECT user,max_questions FROM mysql.user WHERE USER='u11';
652 user u11
653 max_questions 2
654 ALTER USER u11@localhost WITH MAX_QUERIES_PER_HOUR 6;
655 SELECT user,max_questions FROM mysql.user WHERE USER='u11';
656 user u11
657 max_questions 6
658 CREATE USER u12@localhost IDENTIFIED BY 'auth_string'
659 WITH MAX_QUERIES_PER_HOUR 2;
660 SELECT user,max_questions FROM mysql.user WHERE USER='u12';
661 user u12
662 max_questions 2
663 ALTER USER u12@localhost IDENTIFIED WITH 'mysql_native_password'
664 WITH MAX_QUERIES_PER_HOUR 8;
665 SELECT user,max_questions FROM mysql.user WHERE USER='u12';
666 user u12
667 max_questions 8
668 ALTER USER u12@localhost IDENTIFIED WITH 'mysql_native_password'
669 WITH MAX_QUERIES_PER_HOUR 1000;
670 SELECT user,max_questions FROM mysql.user WHERE USER='u12';
671 user u12
672 max_questions 1000
673 CREATE USER u13@localhost IDENTIFIED WITH 'mysql_native_password'
674 WITH MAX_CONNECTIONS_PER_HOUR 2;
675 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
676 plugin,password_expired,
677 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u13';
678 user u13
679 ssl_type
680 ssl_cipher
681 x509_issuer
682 x509_subject
683 plugin mysql_native_password
684 password_expired N
685 password_last_changed #
686 password_lifetime NULL
687 ALTER USER u13@localhost PASSWORD EXPIRE;
688 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
689 plugin,password_expired,
690 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u13';
691 user u13
692 ssl_type
693 ssl_cipher
694 x509_issuer
695 x509_subject
696 plugin mysql_native_password
697 password_expired Y
698 password_last_changed #
699 password_lifetime NULL
700 CREATE USER u14@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
701 WITH MAX_USER_CONNECTIONS 2;
702 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
703 plugin,password_expired,max_user_connections,
704 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u14';
705 user u14
706 ssl_type
707 ssl_cipher
708 x509_issuer
709 x509_subject
710 plugin mysql_native_password
711 password_expired N
712 max_user_connections 2
713 password_last_changed #
714 password_lifetime NULL
715 ALTER USER u14@localhost WITH MAX_USER_CONNECTIONS 12
716 PASSWORD EXPIRE INTERVAL 365 DAY;
717 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
718 plugin,password_expired,max_user_connections,
719 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u14';
720 user u14
721 ssl_type
722 ssl_cipher
723 x509_issuer
724 x509_subject
725 plugin mysql_native_password
726 password_expired N
727 max_user_connections 12
728 password_last_changed #
729 password_lifetime 365
730 CREATE USER tu2@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
731 WITH MAX_USER_CONNECTIONS 2 ;
732 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
733 plugin,password_expired,max_user_connections,max_questions,
734 password_last_changed,password_lifetime FROM mysql.user WHERE USER='tu2';
735 user tu2
736 ssl_type
737 ssl_cipher
738 x509_issuer
739 x509_subject
740 plugin mysql_native_password
741 password_expired N
742 max_user_connections 2
743 max_questions 0
744 password_last_changed #
745 password_lifetime NULL
746 ALTER USER tu2@localhost WITH MAX_USER_CONNECTIONS 12 MAX_QUERIES_PER_HOUR 543
747 PASSWORD EXPIRE INTERVAL 365 DAY;
748 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
749 plugin,password_expired,max_user_connections,max_questions,
750 password_last_changed,password_lifetime FROM mysql.user WHERE USER='tu2';
751 user tu2
752 ssl_type
753 ssl_cipher
754 x509_issuer
755 x509_subject
756 plugin mysql_native_password
757 password_expired N
758 max_user_connections 12
759 max_questions 543
760 password_last_changed #
761 password_lifetime 365
762 SELECT USER();
763 USER()
764 tu2@localhost
765 CREATE USER u15@localhost,
766 u16@localhost IDENTIFIED WITH 'mysql_native_password',
767 u17@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
768 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
769 plugin,password_expired,
770 password_last_changed,password_lifetime FROM mysql.user
771 WHERE USER='u15';
772 user u15
773 ssl_type
774 ssl_cipher
775 x509_issuer
776 x509_subject
777 plugin caching_sha2_password
778 password_expired N
779 password_last_changed #
780 password_lifetime NULL
781 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
782 plugin,password_expired,
783 password_last_changed,password_lifetime FROM mysql.user
784 WHERE USER='u16';
785 user u16
786 ssl_type
787 ssl_cipher
788 x509_issuer
789 x509_subject
790 plugin mysql_native_password
791 password_expired N
792 password_last_changed #
793 password_lifetime NULL
794 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
795 plugin,password_expired,
796 password_last_changed,password_lifetime FROM mysql.user
797 WHERE USER='u17';
798 user u17
799 ssl_type
800 ssl_cipher
801 x509_issuer
802 x509_subject
803 plugin mysql_native_password
804 password_expired N
805 password_last_changed #
806 password_lifetime NULL
807 ALTER USER u15@localhost IDENTIFIED WITH 'mysql_native_password',
808 u16@localhost,
809 u17@localhost IDENTIFIED BY 'new_auth_string'
810 PASSWORD EXPIRE DEFAULT;
811 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
812 plugin,password_expired,
813 password_last_changed,password_lifetime FROM mysql.user
814 WHERE USER='u15';
815 user u15
816 ssl_type
817 ssl_cipher
818 x509_issuer
819 x509_subject
820 plugin mysql_native_password
821 password_expired Y
822 password_last_changed #
823 password_lifetime NULL
824 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
825 plugin,password_expired,
826 password_last_changed,password_lifetime FROM mysql.user
827 WHERE USER='u16';
828 user u16
829 ssl_type
830 ssl_cipher
831 x509_issuer
832 x509_subject
833 plugin mysql_native_password
834 password_expired N
835 password_last_changed #
836 password_lifetime NULL
837 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
838 plugin,password_expired,
839 password_last_changed,password_lifetime FROM mysql.user
840 WHERE USER='u17';
841 user u17
842 ssl_type
843 ssl_cipher
844 x509_issuer
845 x509_subject
846 plugin mysql_native_password
847 password_expired N
848 password_last_changed #
849 password_lifetime NULL
850 CREATE USER u18@localhost,
851 u19@localhost IDENTIFIED BY 'auth_string',
852 u20@localhost IDENTIFIED WITH 'mysql_native_password',
853 u21@localhost IDENTIFIED WITH 'mysql_native_password' BY '!Y_TOdh6)',
854 u22@localhost IDENTIFIED WITH 'mysql_native_password',
855 u23@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_&string'
856 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
857 WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2;
858 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
859 plugin,password_expired,max_user_connections,
860 max_questions,password_last_changed,password_lifetime FROM mysql.user
861 WHERE USER='u18';
862 user u18
863 ssl_type SPECIFIED
864 ssl_cipher
865 x509_issuer
866 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
867 plugin caching_sha2_password
868 password_expired N
869 max_user_connections 2
870 max_questions 2
871 password_last_changed #
872 password_lifetime NULL
873 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
874 plugin,password_expired,max_user_connections,
875 max_questions,password_last_changed,password_lifetime FROM mysql.user
876 WHERE USER='u19';
877 user u19
878 ssl_type SPECIFIED
879 ssl_cipher
880 x509_issuer
881 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
882 plugin caching_sha2_password
883 password_expired N
884 max_user_connections 2
885 max_questions 2
886 password_last_changed #
887 password_lifetime NULL
888 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
889 plugin,password_expired,max_user_connections,
890 max_questions,password_last_changed,password_lifetime FROM mysql.user
891 WHERE USER='u20';
892 user u20
893 ssl_type SPECIFIED
894 ssl_cipher
895 x509_issuer
896 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
897 plugin mysql_native_password
898 password_expired N
899 max_user_connections 2
900 max_questions 2
901 password_last_changed #
902 password_lifetime NULL
903 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
904 plugin,password_expired,max_user_connections,
905 max_questions,password_last_changed,password_lifetime FROM mysql.user
906 WHERE USER='u21';
907 user u21
908 ssl_type SPECIFIED
909 ssl_cipher
910 x509_issuer
911 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
912 plugin mysql_native_password
913 password_expired N
914 max_user_connections 2
915 max_questions 2
916 password_last_changed #
917 password_lifetime NULL
918 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
919 plugin,password_expired,max_user_connections,
920 max_questions,password_last_changed,password_lifetime FROM mysql.user
921 WHERE USER='u22';
922 user u22
923 ssl_type SPECIFIED
924 ssl_cipher
925 x509_issuer
926 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
927 plugin mysql_native_password
928 password_expired N
929 max_user_connections 2
930 max_questions 2
931 password_last_changed #
932 password_lifetime NULL
933 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
934 plugin,password_expired,max_user_connections,
935 max_questions,password_last_changed,password_lifetime FROM mysql.user
936 WHERE USER='u23';
937 user u23
938 ssl_type SPECIFIED
939 ssl_cipher
940 x509_issuer
941 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
942 plugin mysql_native_password
943 password_expired N
944 max_user_connections 2
945 max_questions 2
946 password_last_changed #
947 password_lifetime NULL
948 ALTER USER u18@localhost, u19@localhost,
949 u20@localhost, u21@localhost,
950 u22@localhost, u23@localhost
951 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
952 WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2
953 PASSWORD EXPIRE NEVER;
954 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
955 plugin,password_expired,max_user_connections,
956 max_questions,password_last_changed,password_lifetime FROM mysql.user
957 WHERE USER='u18';
958 user u18
959 ssl_type SPECIFIED
960 ssl_cipher
961 x509_issuer
962 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
963 plugin caching_sha2_password
964 password_expired N
965 max_user_connections 2
966 max_questions 2
967 password_last_changed #
968 password_lifetime 0
969 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
970 plugin,password_expired,max_user_connections,
971 max_questions,password_last_changed,password_lifetime FROM mysql.user
972 WHERE USER='u19';
973 user u19
974 ssl_type SPECIFIED
975 ssl_cipher
976 x509_issuer
977 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
978 plugin caching_sha2_password
979 password_expired N
980 max_user_connections 2
981 max_questions 2
982 password_last_changed #
983 password_lifetime 0
984 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
985 plugin,password_expired,max_user_connections,
986 max_questions,password_last_changed,password_lifetime FROM mysql.user
987 WHERE USER='u20';
988 user u20
989 ssl_type SPECIFIED
990 ssl_cipher
991 x509_issuer
992 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
993 plugin mysql_native_password
994 password_expired N
995 max_user_connections 2
996 max_questions 2
997 password_last_changed #
998 password_lifetime 0
999 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
1000 plugin,password_expired,max_user_connections,
1001 max_questions,password_last_changed,password_lifetime FROM mysql.user
1002 WHERE USER='u21';
1003 user u21
1004 ssl_type SPECIFIED
1005 ssl_cipher
1006 x509_issuer
1007 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
1008 plugin mysql_native_password
1009 password_expired N
1010 max_user_connections 2
1011 max_questions 2
1012 password_last_changed #
1013 password_lifetime 0
1014 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
1015 plugin,password_expired,max_user_connections,
1016 max_questions,password_last_changed,password_lifetime FROM mysql.user
1017 WHERE USER='u22';
1018 user u22
1019 ssl_type SPECIFIED
1020 ssl_cipher
1021 x509_issuer
1022 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
1023 plugin mysql_native_password
1024 password_expired N
1025 max_user_connections 2
1026 max_questions 2
1027 password_last_changed #
1028 password_lifetime 0
1029 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
1030 plugin,password_expired,max_user_connections,
1031 max_questions,password_last_changed,password_lifetime FROM mysql.user
1032 WHERE USER='u23';
1033 user u23
1034 ssl_type SPECIFIED
1035 ssl_cipher
1036 x509_issuer
1037 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
1038 plugin mysql_native_password
1039 password_expired N
1040 max_user_connections 2
1041 max_questions 2
1042 password_last_changed #
1043 password_lifetime 0
1044 DROP USER tu1@localhost,tu2@localhost,u1@localhost, u2@localhost, u3@localhost,
1045 u4@localhost,u5@localhost,u6@localhost, u7@localhost, u8@localhost,
1046 u9@localhost,u10@localhost,u11@localhost,u12@localhost,u13@localhost,
1047 u14@localhost,u15@localhost,u16@localhost,u17@localhost,u18@localhost,
1048 u19@localhost,u20@localhost,u21@localhost,u22@localhost,u23@localhost;
1049 # ALTER USER with current user
1050 CREATE USER u1@localhost IDENTIFIED BY 'abc';
1051 SELECT USER();
1052 USER()
1053 u1@localhost
1054 ALTER USER u1@localhost PASSWORD EXPIRE;
1055 SELECT USER();
1056 ERROR HY000: You must reset your password using ALTER USER statement before executing this statement.
1057 SET PASSWORD = 'def';
1058 SELECT USER();
1059 USER()
1060 u1@localhost
1061 ALTER USER u1@localhost PASSWORD EXPIRE;
1062 SELECT USER();
1063 ERROR HY000: You must reset your password using ALTER USER statement before executing this statement.
1064 ALTER USER IDENTIFIED BY 'npwd';
1065 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY 'npwd'' at line 1
1066 ALTER USER USER() IDENTIFIED BY 'abc';
1067 SELECT USER();
1068 USER()
1069 u1@localhost
1070 ALTER USER u1@localhost PASSWORD EXPIRE;
1071 SELECT USER();
1072 ERROR HY000: You must reset your password using ALTER USER statement before executing this statement.
1073 ALTER USER u1@localhost IDENTIFIED BY 'def';
1074 SELECT USER();
1075 USER()
1076 u1@localhost
1077 DROP USER u1@localhost;
1078 # ALTER USER with current user is allowed to set only credential information
1079 CREATE USER u1@localhost, u2@localhost IDENTIFIED BY 'abc';
1080 GRANT ALL ON *.* TO u2@localhost;
1081 ALTER USER USER() IDENTIFIED WITH 'sha256_password';
1082 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WITH 'sha256_password'' at line 1
1083 ALTER USER USER() IDENTIFIED BY 'def', u2@localhost PASSWORD EXPIRE;
1084 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', u2@localhost PASSWORD EXPIRE' at line 1
1085 ALTER USER USER() IDENTIFIED BY 'def' PASSWORD EXPIRE;
1086 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORD EXPIRE' at line 1
1087 ALTER USER ;
1088 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
1089 ALTER USER u2@localhost IDENTIFIED BY 'auth_string' PASSWORD EXPIRE INTERVAL 45 DAY;
1090 SELECT user,ssl_type,ssl_cipher,x509_issuer,x509_subject,
1091 plugin,password_expired,
1092 password_last_changed,password_lifetime FROM mysql.user WHERE USER='u2';
1093 user u2
1094 ssl_type
1095 ssl_cipher
1096 x509_issuer
1097 x509_subject
1098 plugin caching_sha2_password
1099 password_expired N
1100 password_last_changed #
1101 password_lifetime 45
1102 DROP USER u1@localhost, u2@localhost;
1103 # SHOW CREATE USER
1104 CREATE USER u1@localhost;
1105 SHOW CREATE USER u1@localhost;
1106 CREATE USER for u1@localhost
1107 CREATE USER `u1`@`localhost` IDENTIFIED WITH 'caching_sha2_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1108 CREATE USER u2@localhost IDENTIFIED BY 'auth_string';
1109 SHOW CREATE USER u2@localhost;
1110 CREATE USER for u2@localhost
1111 CREATE USER `u2`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1112 # DDL output for SHOW CREATE USER u2@localhost and recreating user
1113 DROP USER u2@localhost;
1114 CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1115 AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE NONE;
1116 SELECT USER();
1117 USER()
1118 u2@localhost
1119
1120 CREATE USER u3@localhost IDENTIFIED WITH 'mysql_native_password';
1121 SHOW CREATE USER u3@localhost;
1122 CREATE USER for u3@localhost
1123 CREATE USER `u3`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1124 CREATE USER u4@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
1125 SHOW CREATE USER u4@localhost;
1126 CREATE USER for u4@localhost
1127 CREATE USER `u4`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1128 CREATE USER user1@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
1129 SHOW CREATE USER user1@localhost;
1130 CREATE USER for user1@localhost
1131 CREATE USER `user1`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1132
1133 CREATE USER user2@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
1134 SHOW CREATE USER user2@localhost;
1135 CREATE USER for user2@localhost
1136 CREATE USER `user2`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1137
1138 CREATE USER u5@localhost REQUIRE SSL;
1139 SHOW CREATE USER u5@localhost;
1140 CREATE USER for u5@localhost
1141 CREATE USER `u5`@`localhost` IDENTIFIED WITH 'caching_sha2_password' REQUIRE SSL PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1142 CREATE USER u6@localhost IDENTIFIED BY 'auth_string' REQUIRE X509;
1143 SHOW CREATE USER u6@localhost;
1144 CREATE USER for u6@localhost
1145 CREATE USER `u6`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE X509 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1146 CREATE USER u7@localhost IDENTIFIED WITH 'mysql_native_password'
1147 REQUIRE CIPHER 'cipher';
1148 SHOW CREATE USER u7@localhost;
1149 CREATE USER for u7@localhost
1150 CREATE USER `u7`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE CIPHER 'cipher' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1151 CREATE USER u8@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
1152 REQUIRE ISSUER 'issuer';
1153 SHOW CREATE USER u8@localhost;
1154 CREATE USER for u8@localhost
1155 CREATE USER `u8`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE ISSUER 'issuer' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1156 CREATE USER u9@localhost REQUIRE SUBJECT 'sub';
1157 SHOW CREATE USER u9@localhost;
1158 CREATE USER for u9@localhost
1159 CREATE USER `u9`@`localhost` IDENTIFIED WITH 'caching_sha2_password' REQUIRE SUBJECT 'sub' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1160 CREATE USER u10@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
1161 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
1162 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
1163 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA";
1164 SHOW CREATE USER u10@localhost;
1165 CREATE USER for u10@localhost
1166 CREATE USER `u10`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'ECDHE-RSA-AES128-GCM-SHA256' PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1167 CREATE USER u11@localhost WITH MAX_QUERIES_PER_HOUR 2;
1168 SHOW CREATE USER u11@localhost;
1169 CREATE USER for u11@localhost
1170 CREATE USER `u11`@`localhost` IDENTIFIED WITH 'caching_sha2_password' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 2 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1171 CREATE USER u12@localhost IDENTIFIED BY 'auth_string' WITH MAX_QUERIES_PER_HOUR 2;
1172 SHOW CREATE USER u12@localhost;
1173 CREATE USER for u12@localhost
1174 CREATE USER `u12`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 2 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1175 CREATE USER u13@localhost IDENTIFIED WITH 'mysql_native_password'
1176 WITH MAX_CONNECTIONS_PER_HOUR 2;
1177 SHOW CREATE USER u13@localhost;
1178 CREATE USER for u13@localhost
1179 CREATE USER `u13`@`localhost` IDENTIFIED WITH 'mysql_native_password' REQUIRE NONE WITH MAX_CONNECTIONS_PER_HOUR 2 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1180 CREATE USER u14@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
1181 WITH MAX_USER_CONNECTIONS 2;
1182 SHOW CREATE USER u14@localhost;
1183 CREATE USER for u14@localhost
1184 CREATE USER `u14`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE NONE WITH MAX_USER_CONNECTIONS 2 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1185 CREATE USER u15@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
1186 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
1187 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
1188 CIPHER 'cipher' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2;
1189 SHOW CREATE USER u15@localhost;
1190 CREATE USER for u15@localhost
1191 CREATE USER `u15`@`localhost` IDENTIFIED WITH 'mysql_native_password' AS '<non-deterministic-password-hash>' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'cipher' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2 PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT
1192 DROP USER user1@localhost,u1@localhost,u2@localhost,u3@localhost,u4@localhost,
1193 u5@localhost,u6@localhost, u7@localhost, u8@localhost,u9@localhost,
1194 u10@localhost,u11@localhost,u12@localhost,u13@localhost,u14@localhost,
1195 u15@localhost;
1196
1197 # GRANT
1198
1199 CREATE USER user1@localhost IDENTIFIED WITH 'mysql_native_password'
1200 AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1201 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
1202 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
1203 WITH MAX_CONNECTIONS_PER_HOUR 1000 MAX_USER_CONNECTIONS 20
1204 MAX_QUERIES_PER_HOUR 60 MAX_UPDATES_PER_HOUR 100;
1205 SELECT user,plugin,ssl_type,ssl_cipher,
1206 x509_issuer,x509_subject,max_user_connections,
1207 max_questions,max_updates,max_connections FROM mysql.user
1208 WHERE USER='user1';
1209 user user1
1210 plugin mysql_native_password
1211 ssl_type SPECIFIED
1212 ssl_cipher
1213 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
1214 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
1215 max_user_connections 20
1216 max_questions 60
1217 max_updates 100
1218 max_connections 1000
1219
1220 GRANT SELECT ON *.* TO user1@localhost;
1221 GRANT SELECT,INSERT,UPDATE ON mysql.* TO user1@localhost;
1222
1223 SHOW GRANTS FOR user1@localhost;
1224 Grants for user1@localhost
1225 GRANT SELECT ON *.* TO `user1`@`localhost`
1226 GRANT SELECT, INSERT, UPDATE ON `mysql`.* TO `user1`@`localhost`
1227
1228 REVOKE INSERT,UPDATE ON mysql.* FROM user1@localhost;
1229 SHOW GRANTS FOR user1@localhost;
1230 Grants for user1@localhost
1231 GRANT SELECT ON *.* TO `user1`@`localhost`
1232 GRANT SELECT ON `mysql`.* TO `user1`@`localhost`
1233
1234 GRANT SELECT,INSERT,UPDATE ON *.* TO user2@localhost;
1235 ALTER USER user2@localhost IDENTIFIED BY 'admin'
1236 REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client'
1237 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
1238 WITH MAX_CONNECTIONS_PER_HOUR 1000 MAX_USER_CONNECTIONS 20
1239 MAX_QUERIES_PER_HOUR 60 MAX_UPDATES_PER_HOUR 100;
1240 SELECT user,plugin,ssl_type,ssl_cipher,
1241 x509_issuer,x509_subject,max_user_connections,
1242 max_questions,max_updates,max_connections FROM mysql.user WHERE USER='user2';
1243 user user2
1244 plugin mysql_native_password
1245 ssl_type SPECIFIED
1246 ssl_cipher
1247 x509_issuer /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA
1248 x509_subject /C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client
1249 max_user_connections 20
1250 max_questions 60
1251 max_updates 100
1252 max_connections 1000
1253 CREATE USER user3@localhost IDENTIFIED BY 'auth_string';
1254 # Cleanup
1255 DROP USER user1@localhost,user2@localhost,user3@localhost;
1256
1257 # SET PASSWORD Tests
1258
1259 CREATE USER user1@localhost IDENTIFIED BY 'auth_string';
1260 CREATE USER user2@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string1';
1261 SET PASSWORD FOR user1@localhost='auth_xyz@';
1262 SET PASSWORD FOR user2@localhost='gd636@gj';
1263
1264 CREATE USER user4@localhost;
1265 ALTER USER user4@localhost PASSWORD EXPIRE;
1266 SET PASSWORD FOR user4@localhost='';
1267 CREATE USER user3@localhost IDENTIFIED BY 'auth_string';
1268 CREATE USER user5@localhost IDENTIFIED WITH 'mysql_native_password' BY 'auth_string1';
1269 SET PASSWORD FOR user3@localhost='auth_abc';
1270 GRANT SELECT ON *.* TO user3@localhost;
1271 SELECT USER();
1272 USER()
1273 user3@localhost
1274 SET PASSWORD='auth_xyz';
1275 SELECT user,plugin,ssl_type,password_expired,
1276 password_lifetime FROM mysql.user WHERE user='user3';
1277 user user3
1278 plugin caching_sha2_password
1279 ssl_type
1280 password_expired N
1281 password_lifetime NULL
1282
1283 SET PASSWORD FOR user4@localhost='auth_xyz';
1284 SELECT user,plugin,ssl_type,password_expired,
1285 password_lifetime FROM mysql.user WHERE user='user4';
1286 user user4
1287 plugin caching_sha2_password
1288 ssl_type
1289 password_expired N
1290 password_lifetime NULL
1291
1292 SET PASSWORD FOR user5@localhost='auth_dhsga5';
1293 SELECT user,plugin,ssl_type,password_expired,
1294 password_lifetime FROM mysql.user WHERE user='user5';
1295 user user5
1296 plugin mysql_native_password
1297 ssl_type
1298 password_expired N
1299 password_lifetime NULL
1300
1301 CREATE USER user6@localhost IDENTIFIED BY 'auth_string';
1302 SELECT user,plugin,password_expired
1303 FROM mysql.user WHERE USER='user6';
1304 user user6
1305 plugin caching_sha2_password
1306 password_expired N
1307 ALTER USER user6@localhost IDENTIFIED WITH 'mysql_native_password';
1308 SELECT user,plugin,password_expired
1309 FROM mysql.user WHERE USER='user6';
1310 user user6
1311 plugin mysql_native_password
1312 password_expired Y
1313 SET PASSWORD FOR user6@localhost='plaintext_password';
1314 SELECT user,plugin
1315 FROM mysql.user WHERE USER='user6';
1316 user user6
1317 plugin mysql_native_password
1318 SELECT USER();
1319 USER()
1320 user6@localhost
1321
1322 # Cleanup
1323 DROP USER user1@localhost,user2@localhost,user3@localhost,
1324 user4@localhost,user5@localhost,user6@localhost;
1325 include/sync_slave_sql_with_master.inc
1326 [On Slave]
1327 include/show_binlog_events.inc
1328 Log_name Pos Event_type Server_id End_log_pos Info
1329 slave-bin.000001 # Query # # use `test`; CREATE USER 'user1'@'%' IDENTIFIED WITH 'caching_sha2_password'
1330 slave-bin.000001 # Query # # use `test`; CREATE USER 'user2'@'%' IDENTIFIED WITH 'caching_sha2_password'
1331 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
1332 slave-bin.000001 # Query # # use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' ACCOUNT LOCK
1333 slave-bin.000001 # Query # # use `test`; CREATE USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1334 slave-bin.000001 # Query # # use `test`; CREATE USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1335 slave-bin.000001 # Query # # use `test`; CREATE USER 'user4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1336 slave-bin.000001 # Query # # use `test`; CREATE USER 'user6'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1337 slave-bin.000001 # Query # # use `test`; CREATE USER 'user7'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*1643D320B9787E87A3C6CE2C953B9E4FDBC048BC' PASSWORD EXPIRE NEVER ACCOUNT UNLOCK
1338 slave-bin.000001 # Query # # use `test`; CREATE USER 'user8'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1339 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu1'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1340 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*688BC28176C50B8E37AB2D9BDFDCC945AD0CAD61'
1341 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*4CB92EE3F6DCB4480A1ED46B0B82E3E6180947D5'
1342 slave-bin.000001 # Query # # use `test`; CREATE USER 'u5'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SSL
1343 slave-bin.000001 # Query # # use `test`; CREATE USER 'u6'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE X509
1344 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*0D38B5A8766439BA457E3FDFAF84D794245A1C8B' REQUIRE SSL
1345 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu5'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*87CAAC9F8E0664808E450E3E9D4CCCA455FB90F0' REQUIRE X509
1346 slave-bin.000001 # Query # # use `test`; CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'mysql_native_password' REQUIRE CIPHER 'cipher'
1347 slave-bin.000001 # Query # # use `test`; CREATE USER 'u8'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA'
1348 slave-bin.000001 # Query # # use `test`; CREATE USER 'u9'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SUBJECT 'sub'
1349 slave-bin.000001 # Query # # use `test`; CREATE USER 'u10'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*D0B4490FF0452CF4EAA50F79F6B06F859FA2B012' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1350 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu6'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*6F268C32216139F3B99FEBA90FC68F8D9651382A' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'ECDHE-RSA-AES128-GCM-SHA256' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2
1351 slave-bin.000001 # Query # # use `test`; CREATE USER 'u11'@'localhost' IDENTIFIED WITH 'caching_sha2_password' WITH MAX_QUERIES_PER_HOUR 2
1352 slave-bin.000001 # Query # # use `test`; CREATE USER 'u12'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' WITH MAX_QUERIES_PER_HOUR 2
1353 slave-bin.000001 # Query # # use `test`; CREATE USER 'u13'@'localhost' IDENTIFIED WITH 'mysql_native_password' WITH MAX_CONNECTIONS_PER_HOUR 2
1354 slave-bin.000001 # Query # # use `test`; CREATE USER 'u14'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WITH MAX_USER_CONNECTIONS 2 ACCOUNT LOCK
1355 slave-bin.000001 # Query # # use `test`; CREATE USER 'u15'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u16'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1356 slave-bin.000001 # Query # # use `test`; CREATE USER 'u18'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u19'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2 ACCOUNT UNLOCK
1357 slave-bin.000001 # Query # # use `test`; DROP USER tu1@localhost,tu2@localhost,tu3@localhost,tu4@localhost,tu5@localhost,
1358 tu6@localhost,user1@'%',user2@'%',user4@localhost,user6@localhost,
1359 user7@localhost,user8@localhost, u1@localhost,u2@localhost,u3@localhost,
1360 u4@localhost,u5@localhost,u6@localhost, u7@localhost, u8@localhost,
1361 u9@localhost, u10@localhost,u11@localhost, u12@localhost,u13@localhost,
1362 u14@localhost,u15@localhost,u16@localhost,u17@localhost,u18@localhost,
1363 u19@localhost, u20@localhost,u21@localhost,u22@localhost,u23@localhost
1364 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
1365 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost'
1366 slave-bin.000001 # Query # # use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1367 slave-bin.000001 # Query # # use `test`; ALTER USER 'u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1368 slave-bin.000001 # Query # # use `test`; CREATE USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' ACCOUNT LOCK
1369 slave-bin.000001 # Query # # use `test`; ALTER USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' PASSWORD EXPIRE NEVER ACCOUNT UNLOCK
1370 slave-bin.000001 # Query # # use `test`; ALTER USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1371 slave-bin.000001 # Query # # use `test`; ALTER USER 'u3'@'localhost' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2 PASSWORD EXPIRE NEVER
1372 slave-bin.000001 # Query # # use `test`; CREATE USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' PASSWORD EXPIRE DEFAULT ACCOUNT LOCK
1373 slave-bin.000001 # Query # # use `test`; ALTER USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' ACCOUNT UNLOCK
1374 slave-bin.000001 # Query # # use `test`; CREATE USER 'u5'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SSL
1375 slave-bin.000001 # Query # # use `test`; ALTER USER 'u5'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1376 slave-bin.000001 # Query # # use `test`; ALTER USER 'u5'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*5B3304C97AB136DEBC2C0B46336F27398F7AEFB6'
1377 slave-bin.000001 # Query # # use `test`; CREATE USER 'u6'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE X509 PASSWORD EXPIRE INTERVAL 80 DAY ACCOUNT LOCK
1378 slave-bin.000001 # Query # # use `test`; ALTER USER 'u6'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*5B3304C97AB136DEBC2C0B46336F27398F7AEFB6' REQUIRE SSL ACCOUNT UNLOCK
1379 slave-bin.000001 # Query # # use `test`; CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1380 slave-bin.000001 # Query # # use `test`; ALTER USER 'u7'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*5B3304C97AB136DEBC2C0B46336F27398F7AEFB6' REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' ACCOUNT UNLOCK
1381 slave-bin.000001 # Query # # use `test`; CREATE USER 'u8'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA'
1382 slave-bin.000001 # Query # # use `test`; ALTER USER 'u8'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1383 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE ISSUER 'issuer'
1384 slave-bin.000001 # Query # # use `test`; ALTER USER 'tu1'@'localhost' IDENTIFIED WITH 'mysql_native_password' REQUIRE CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1385 slave-bin.000001 # Query # # use `test`; CREATE USER 'u9'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SUBJECT 'sub'
1386 slave-bin.000001 # Query # # use `test`; ALTER USER 'u9'@'localhost' REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA'
1387 slave-bin.000001 # Query # # use `test`; ALTER USER 'u9'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*AEEAD8F349FAED7CA659DCEFCEC2F0BF90241263' REQUIRE ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA'
1388 slave-bin.000001 # Query # # use `test`; CREATE USER 'u10'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1389 slave-bin.000001 # Query # # use `test`; ALTER USER 'u10'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE SSL
1390 slave-bin.000001 # Query # # use `test`; CREATE USER 'u11'@'localhost' IDENTIFIED WITH 'caching_sha2_password' WITH MAX_QUERIES_PER_HOUR 2
1391 slave-bin.000001 # Query # # use `test`; ALTER USER 'u11'@'localhost' WITH MAX_QUERIES_PER_HOUR 6
1392 slave-bin.000001 # Query # # use `test`; CREATE USER 'u12'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' WITH MAX_QUERIES_PER_HOUR 2
1393 slave-bin.000001 # Query # # use `test`; ALTER USER 'u12'@'localhost' IDENTIFIED WITH 'mysql_native_password' WITH MAX_QUERIES_PER_HOUR 8
1394 slave-bin.000001 # Query # # use `test`; ALTER USER 'u12'@'localhost' IDENTIFIED WITH 'mysql_native_password' WITH MAX_QUERIES_PER_HOUR 1000
1395 slave-bin.000001 # Query # # use `test`; CREATE USER 'u13'@'localhost' IDENTIFIED WITH 'mysql_native_password' WITH MAX_CONNECTIONS_PER_HOUR 2
1396 slave-bin.000001 # Query # # use `test`; ALTER USER 'u13'@'localhost' PASSWORD EXPIRE
1397 slave-bin.000001 # Query # # use `test`; CREATE USER 'u14'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WITH MAX_USER_CONNECTIONS 2
1398 slave-bin.000001 # Query # # use `test`; ALTER USER 'u14'@'localhost' WITH MAX_USER_CONNECTIONS 12 PASSWORD EXPIRE INTERVAL 365 DAY
1399 slave-bin.000001 # Query # # use `test`; CREATE USER 'tu2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WITH MAX_USER_CONNECTIONS 2
1400 slave-bin.000001 # Query # # use `test`; ALTER USER 'tu2'@'localhost' WITH MAX_QUERIES_PER_HOUR 543 MAX_USER_CONNECTIONS 12 PASSWORD EXPIRE INTERVAL 365 DAY
1401 slave-bin.000001 # Query # # use `test`; CREATE USER 'u15'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u16'@'localhost' IDENTIFIED WITH 'mysql_native_password','u17'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1402 slave-bin.000001 # Query # # use `test`; ALTER USER 'u15'@'localhost' IDENTIFIED WITH 'mysql_native_password','u16'@'localhost','u17'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*5B3304C97AB136DEBC2C0B46336F27398F7AEFB6' PASSWORD EXPIRE DEFAULT
1403 slave-bin.000001 # Query # # use `test`; CREATE USER 'u18'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u19'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2
1404 slave-bin.000001 # Query # # use `test`; ALTER USER 'u18'@'localhost','u19'@'localhost','u20'@'localhost','u21'@'localhost','u22'@'localhost','u23'@'localhost' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2 PASSWORD EXPIRE NEVER
1405 slave-bin.000001 # Query # # use `test`; DROP USER tu1@localhost,tu2@localhost,u1@localhost, u2@localhost, u3@localhost,
1406 u4@localhost,u5@localhost,u6@localhost, u7@localhost, u8@localhost,
1407 u9@localhost,u10@localhost,u11@localhost,u12@localhost,u13@localhost,
1408 u14@localhost,u15@localhost,u16@localhost,u17@localhost,u18@localhost,
1409 u19@localhost,u20@localhost,u21@localhost,u22@localhost,u23@localhost
1410 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1411 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' PASSWORD EXPIRE
1412 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1413 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' PASSWORD EXPIRE
1414 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1415 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' PASSWORD EXPIRE
1416 slave-bin.000001 # Query # # use `test`; ALTER USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1417 slave-bin.000001 # Query # # use `test`; DROP USER u1@localhost
1418 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1419 slave-bin.000001 # Query # # use `test`; GRANT ALL PRIVILEGES ON *.* TO 'u2'@'localhost'
1420 slave-bin.000001 # Query # # use `test`; ALTER USER 'u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' PASSWORD EXPIRE INTERVAL 45 DAY
1421 slave-bin.000001 # Query # # use `test`; DROP USER u1@localhost, u2@localhost
1422 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
1423 slave-bin.000001 # Query # # use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1424 slave-bin.000001 # Query # # use `test`; DROP USER u2@localhost
1425 slave-bin.000001 # Query # # use `test`; CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE NONE
1426 slave-bin.000001 # Query # # use `test`; CREATE USER 'u3'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1427 slave-bin.000001 # Query # # use `test`; CREATE USER 'u4'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1428 slave-bin.000001 # Query # # use `test`; CREATE USER 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1429 slave-bin.000001 # Query # # use `test`; CREATE USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF'
1430 slave-bin.000001 # Query # # use `test`; CREATE USER 'u5'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SSL
1431 slave-bin.000001 # Query # # use `test`; CREATE USER 'u6'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' REQUIRE X509
1432 slave-bin.000001 # Query # # use `test`; CREATE USER 'u7'@'localhost' IDENTIFIED WITH 'mysql_native_password' REQUIRE CIPHER 'cipher'
1433 slave-bin.000001 # Query # # use `test`; CREATE USER 'u8'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE ISSUER 'issuer'
1434 slave-bin.000001 # Query # # use `test`; CREATE USER 'u9'@'localhost' IDENTIFIED WITH 'caching_sha2_password' REQUIRE SUBJECT 'sub'
1435 slave-bin.000001 # Query # # use `test`; CREATE USER 'u10'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'ECDHE-RSA-AES128-GCM-SHA256'
1436 slave-bin.000001 # Query # # use `test`; CREATE USER 'u11'@'localhost' IDENTIFIED WITH 'caching_sha2_password' WITH MAX_QUERIES_PER_HOUR 2
1437 slave-bin.000001 # Query # # use `test`; CREATE USER 'u12'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>' WITH MAX_QUERIES_PER_HOUR 2
1438 slave-bin.000001 # Query # # use `test`; CREATE USER 'u13'@'localhost' IDENTIFIED WITH 'mysql_native_password' WITH MAX_CONNECTIONS_PER_HOUR 2
1439 slave-bin.000001 # Query # # use `test`; CREATE USER 'u14'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WITH MAX_USER_CONNECTIONS 2
1440 slave-bin.000001 # Query # # use `test`; CREATE USER 'u15'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' CIPHER 'cipher' WITH MAX_QUERIES_PER_HOUR 2 MAX_USER_CONNECTIONS 2
1441 slave-bin.000001 # Query # # use `test`; DROP USER user1@localhost,u1@localhost,u2@localhost,u3@localhost,u4@localhost,
1442 u5@localhost,u6@localhost, u7@localhost, u8@localhost,u9@localhost,
1443 u10@localhost,u11@localhost,u12@localhost,u13@localhost,u14@localhost,
1444 u15@localhost
1445 slave-bin.000001 # Query # # use `test`; CREATE USER 'user1'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' WITH MAX_QUERIES_PER_HOUR 60 MAX_UPDATES_PER_HOUR 100 MAX_CONNECTIONS_PER_HOUR 1000 MAX_USER_CONNECTIONS 20
1446 slave-bin.000001 # Query # # use `test`; GRANT SELECT ON *.* TO 'user1'@'localhost'
1447 slave-bin.000001 # Query # # use `test`; GRANT SELECT, INSERT, UPDATE ON `mysql`.* TO 'user1'@'localhost'
1448 slave-bin.000001 # Query # # use `test`; REVOKE INSERT,UPDATE ON mysql.* FROM user1@localhost
1449 slave-bin.000001 # Query # # use `test`; GRANT SELECT, INSERT, UPDATE ON *.* TO 'user2'@'localhost'
1450 slave-bin.000001 # Query # # use `test`; ALTER USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*4ACFE3202A5FF5CF467898FC58AAB1D615029441' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client' ISSUER '/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA' WITH MAX_QUERIES_PER_HOUR 60 MAX_UPDATES_PER_HOUR 100 MAX_CONNECTIONS_PER_HOUR 1000 MAX_USER_CONNECTIONS 20
1451 slave-bin.000001 # Query # # use `test`; CREATE USER 'user3'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1452 slave-bin.000001 # Query # # use `test`; DROP USER user1@localhost,user2@localhost,user3@localhost
1453 slave-bin.000001 # Query # # use `test`; CREATE USER 'user1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1454 slave-bin.000001 # Query # # use `test`; CREATE USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BB2A6C4B68EBE1B781C294D655785971401FB13B'
1455 slave-bin.000001 # Query # # use `test`; ALTER USER 'user1'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1456 slave-bin.000001 # Query # # use `test`; ALTER USER 'user2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*F03819CC796CCA4052B8928179B81D18288B05A8'
1457 slave-bin.000001 # Query # # use `test`; CREATE USER 'user4'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
1458 slave-bin.000001 # Query # # use `test`; ALTER USER 'user4'@'localhost' PASSWORD EXPIRE
1459 slave-bin.000001 # Query # # use `test`; ALTER USER 'user4'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
1460 slave-bin.000001 # Query # # use `test`; CREATE USER 'user3'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1461 slave-bin.000001 # Query # # use `test`; CREATE USER 'user5'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*BB2A6C4B68EBE1B781C294D655785971401FB13B'
1462 slave-bin.000001 # Query # # use `test`; ALTER USER 'user3'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1463 slave-bin.000001 # Query # # use `test`; GRANT SELECT ON *.* TO 'user3'@'localhost'
1464 slave-bin.000001 # Query # # use `test`; ALTER USER 'user3'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1465 slave-bin.000001 # Query # # use `test`; ALTER USER 'user4'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1466 slave-bin.000001 # Query # # use `test`; ALTER USER 'user5'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*960F0A06F105B0FE8089E3F6FAD5369E8A28E241'
1467 slave-bin.000001 # Query # # use `test`; CREATE USER 'user6'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
1468 slave-bin.000001 # Query # # use `test`; ALTER USER 'user6'@'localhost' IDENTIFIED WITH 'mysql_native_password'
1469 slave-bin.000001 # Query # # use `test`; ALTER USER 'user6'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*9CAB2BAE176801E82ABA9E55CCCDDBF388E0301D'
1470 slave-bin.000001 # Query # # use `test`; DROP USER user1@localhost,user2@localhost,user3@localhost,
1471 user4@localhost,user5@localhost,user6@localhost
1472 include/rpl_end.inc
1473
1474 End of 5.7 tests!
1475