Debian Codegraph @

mysql-test/suite/sys_vars/r/caching_sha2_password_digest_rounds_basic.result

raw
1 SELECT @@global.caching_sha2_password_digest_rounds;
2 @@global.caching_sha2_password_digest_rounds
3 5000
4 CREATE USER wl_14281_default@localhost IDENTIFIED WITH caching_sha2_password BY 'WL_14281_PASSWORD';
5 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_default';
6 length
7 005
8 SELECT user FROM information_schema.USER_ATTRIBUTES;
9 USER
10 wl_14281_default
11 SET PERSIST_ONLY caching_sha2_password_digest_rounds=7000;
12 # restart
13 SELECT @@global.caching_sha2_password_digest_rounds;
14 @@global.caching_sha2_password_digest_rounds
15 7000
16 CREATE USER wl_14281_7000@localhost IDENTIFIED WITH caching_sha2_password BY 'WL_14281_PASSWORD';
17 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_7000';
18 length
19 007
20 SELECT user FROM information_schema.USER_ATTRIBUTES;
21 USER
22 wl_14281_7000
23 SELECT user FROM information_schema.USER_ATTRIBUTES;
24 USER
25 wl_14281_default
26 SET PERSIST_ONLY caching_sha2_password_digest_rounds=999000;
27 # restart
28 SELECT @@global.caching_sha2_password_digest_rounds;
29 @@global.caching_sha2_password_digest_rounds
30 999000
31 CREATE USER wl_14281_xl@localhost IDENTIFIED WITH caching_sha2_password BY 'WL_14281_PASSWORD';
32 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_xl';
33 length
34 3E7
35 SELECT user FROM information_schema.USER_ATTRIBUTES;
36 USER
37 wl_14281_xl
38 SELECT user FROM information_schema.USER_ATTRIBUTES;
39 USER
40 wl_14281_7000
41 SELECT user FROM information_schema.USER_ATTRIBUTES;
42 USER
43 wl_14281_default
44 RESET PERSIST caching_sha2_password_digest_rounds;
45 # restart
46 SELECT @@global.caching_sha2_password_digest_rounds;
47 @@global.caching_sha2_password_digest_rounds
48 5000
49 SELECT SUBSTRING(authentication_string, 4,3) AS length FROM mysql.user WHERE user='wl_14281_default';
50 length
51 005
52 SELECT user FROM information_schema.USER_ATTRIBUTES;
53 USER
54 wl_14281_xl
55 SELECT user FROM information_schema.USER_ATTRIBUTES;
56 USER
57 wl_14281_7000
58 SELECT user FROM information_schema.USER_ATTRIBUTES;
59 USER
60 wl_14281_default
61 DROP USER wl_14281_default@localhost;
62 DROP USER wl_14281_7000@localhost;
63 DROP USER wl_14281_xl@localhost;