Debian Codegraph @

mysql-test/suite/x/r/caching_sha2_password_digest_rounds.result

raw
1
2
3 ## I. Verify that password hashes created with default digest-rounds
4 ## can be used with X Plugin & X Client
5 #
6 # 1. Show that accounts original credentials are working,
7 # change accounts credentials using (set password, alter user).
8 # 2. Show that old credentials doesn't work.
9 # 3. Show that new credentials are working.
10 #
11 ## II. Verify that password hashes created with default digest-rounds
12 ## and changed with new digest-rounds can be used with X Plugin & X Client
13 # 1. Change servers digest-rounds
14 # 2. Show that accounts original credentials are working,
15 # change accounts credentials to generate a password-hash using new
16 # digest-rounds (set password, alter user).
17 # 3. Show that old credentials doesn't work.
18 # 4. Show that new credentials are working.
19 #
20 #
21 CREATE USER 'change_pwd_alter'@'%' IDENTIFIED WITH caching_sha2_password BY 'alter1';
22 CREATE USER 'change_pwd_set'@'%' IDENTIFIED WITH caching_sha2_password BY 'set1';
23
24 #
25 # I.1
26 RUN ALTER USER 'change_pwd_alter'@'%' IDENTIFIED BY 'alter2'
27
28
29 0 rows affected
30 Mysqlx.Ok {
31 msg: "bye!"
32 }
33 ok
34 RUN SET PASSWORD='set2'
35
36
37 0 rows affected
38 Mysqlx.Ok {
39 msg: "bye!"
40 }
41 ok
42
43 #
44 # I.2
45 Application terminated with expected error: Access denied for user 'change_pwd_alter'@'localhost' (using password: YES) (code 1045)
46 ok
47 Application terminated with expected error: Access denied for user 'change_pwd_set'@'localhost' (using password: YES) (code 1045)
48 ok
49
50 #
51 # I.3
52 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED
53
54 THIS_MUST_BE_EXECUTED
55 ok
56 0 rows affected
57 Mysqlx.Ok {
58 msg: "bye!"
59 }
60 ok
61 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED
62
63 THIS_MUST_BE_EXECUTED
64 ok
65 0 rows affected
66 Mysqlx.Ok {
67 msg: "bye!"
68 }
69 ok
70 DROP USER 'change_pwd_alter'@'%';
71 DROP USER 'change_pwd_set'@'%';
72 DROP USER IF EXISTS 'create_pwd'@'%';
73 Warnings:
74 Note 3162 Authorization ID 'create_pwd'@'%' does not exist.
75 CREATE USER 'change_pwd_alter'@'%' IDENTIFIED WITH caching_sha2_password BY 'alter1';
76 CREATE USER 'change_pwd_set'@'%' IDENTIFIED WITH caching_sha2_password BY 'set1';
77
78 #
79 # II.1
80 # restart: --caching_sha2_password_digest_rounds=10000
81 CREATE USER 'create_pwd'@'%' IDENTIFIED WITH caching_sha2_password BY 'create2';
82
83 #
84 # II.2
85 RUN ALTER USER 'change_pwd_alter'@'%' IDENTIFIED BY 'alter2'
86
87
88 0 rows affected
89 Mysqlx.Ok {
90 msg: "bye!"
91 }
92 ok
93 RUN SET PASSWORD='set2'
94
95
96 0 rows affected
97 Mysqlx.Ok {
98 msg: "bye!"
99 }
100 ok
101
102 #
103 # II.3
104 Application terminated with expected error: Access denied for user 'change_pwd_alter'@'localhost' (using password: YES) (code 1045)
105 ok
106 Application terminated with expected error: Access denied for user 'change_pwd_set'@'localhost' (using password: YES) (code 1045)
107 ok
108
109 #
110 # II.4
111 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED
112
113 THIS_MUST_BE_EXECUTED
114 ok
115 0 rows affected
116 Mysqlx.Ok {
117 msg: "bye!"
118 }
119 ok
120 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED
121
122 THIS_MUST_BE_EXECUTED
123 ok
124 0 rows affected
125 Mysqlx.Ok {
126 msg: "bye!"
127 }
128 ok
129 RUN SELECT 'ok' as THIS_MUST_BE_EXECUTED
130
131 THIS_MUST_BE_EXECUTED
132 ok
133 0 rows affected
134 Mysqlx.Ok {
135 msg: "bye!"
136 }
137 ok
138 # restart:
139 DROP USER 'change_pwd_alter'@'%';
140 DROP USER 'change_pwd_set'@'%';
141 DROP USER IF EXISTS 'create_pwd'@'%';