Debian Codegraph @

mysql-test/suite/auth_sec/r/multiple_passwords.result

raw
1 #-----------------------------------------------------------------------
2 #-----------------------------------------------------------------------
3 # Setup : Create users
4 CREATE USER arthurdent@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
5 #-----------------------------------------------------------------------
6 # Second password tests
7 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
8 mysql: [Warning] Using a password on the command line interface can be insecure.
9 CURRENT_USER()
10 arthurdent@localhost
11 mysql: [Warning] Using a password on the command line interface can be insecure.
12 CURRENT_USER()
13 arthurdent@localhost
14 mysql: [Warning] Using a password on the command line interface can be insecure.
15 CURRENT_USER()
16 arthurdent@localhost
17 mysql: [Warning] Using a password on the command line interface can be insecure.
18 CURRENT_USER()
19 arthurdent@localhost
20 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
21 mysql: [Warning] Using a password on the command line interface can be insecure.
22 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
23 mysql: [Warning] Using a password on the command line interface can be insecure.
24 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
25 mysql: [Warning] Using a password on the command line interface can be insecure.
26 CURRENT_USER()
27 arthurdent@localhost
28 mysql: [Warning] Using a password on the command line interface can be insecure.
29 CURRENT_USER()
30 arthurdent@localhost
31 ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
32 mysql: [Warning] Using a password on the command line interface can be insecure.
33 CURRENT_USER()
34 arthurdent@localhost
35 mysql: [Warning] Using a password on the command line interface can be insecure.
36 CURRENT_USER()
37 arthurdent@localhost
38 mysql: [Warning] Using a password on the command line interface can be insecure.
39 CURRENT_USER()
40 arthurdent@localhost
41 mysql: [Warning] Using a password on the command line interface can be insecure.
42 CURRENT_USER()
43 arthurdent@localhost
44 ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
45 mysql: [Warning] Using a password on the command line interface can be insecure.
46 CURRENT_USER()
47 arthurdent@localhost
48 mysql: [Warning] Using a password on the command line interface can be insecure.
49 CURRENT_USER()
50 arthurdent@localhost
51 mysql: [Warning] Using a password on the command line interface can be insecure.
52 CURRENT_USER()
53 arthurdent@localhost
54 mysql: [Warning] Using a password on the command line interface can be insecure.
55 CURRENT_USER()
56 arthurdent@localhost
57 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
58 SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
59 mysql: [Warning] Using a password on the command line interface can be insecure.
60 CURRENT_USER()
61 arthurdent@localhost
62 mysql: [Warning] Using a password on the command line interface can be insecure.
63 CURRENT_USER()
64 arthurdent@localhost
65 mysql: [Warning] Using a password on the command line interface can be insecure.
66 CURRENT_USER()
67 arthurdent@localhost
68 mysql: [Warning] Using a password on the command line interface can be insecure.
69 CURRENT_USER()
70 arthurdent@localhost
71 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
72 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
73 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
74 ALTER USER arthurdent@localhost PASSWORD EXPIRE;
75 mysql: [Warning] Using a password on the command line interface can be insecure.
76 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
77 mysql: [Warning] Using a password on the command line interface can be insecure.
78 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
79 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
80 GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
81 mysql: [Warning] Using a password on the command line interface can be insecure.
82 mysql: [Warning] Using a password on the command line interface can be insecure.
83 1
84 1
85 mysql: [Warning] Using a password on the command line interface can be insecure.
86 mysql: [Warning] Using a password on the command line interface can be insecure.
87 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
88 mysql: [Warning] Using a password on the command line interface can be insecure.
89 1
90 1
91 #-----------------------------------------------------------------------
92 # Cleanup
93 DROP USER arthurdent@localhost;
94 #-----------------------------------------------------------------------
95 #-----------------------------------------------------------------------
96 # Setup : Create users
97 CREATE USER arthurdent@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
98 #-----------------------------------------------------------------------
99 # Second password tests
100 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
101 mysql: [Warning] Using a password on the command line interface can be insecure.
102 CURRENT_USER()
103 arthurdent@localhost
104 mysql: [Warning] Using a password on the command line interface can be insecure.
105 CURRENT_USER()
106 arthurdent@localhost
107 mysql: [Warning] Using a password on the command line interface can be insecure.
108 CURRENT_USER()
109 arthurdent@localhost
110 mysql: [Warning] Using a password on the command line interface can be insecure.
111 CURRENT_USER()
112 arthurdent@localhost
113 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
114 mysql: [Warning] Using a password on the command line interface can be insecure.
115 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
116 mysql: [Warning] Using a password on the command line interface can be insecure.
117 ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
118 mysql: [Warning] Using a password on the command line interface can be insecure.
119 CURRENT_USER()
120 arthurdent@localhost
121 mysql: [Warning] Using a password on the command line interface can be insecure.
122 CURRENT_USER()
123 arthurdent@localhost
124 ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
125 mysql: [Warning] Using a password on the command line interface can be insecure.
126 CURRENT_USER()
127 arthurdent@localhost
128 mysql: [Warning] Using a password on the command line interface can be insecure.
129 CURRENT_USER()
130 arthurdent@localhost
131 mysql: [Warning] Using a password on the command line interface can be insecure.
132 CURRENT_USER()
133 arthurdent@localhost
134 mysql: [Warning] Using a password on the command line interface can be insecure.
135 CURRENT_USER()
136 arthurdent@localhost
137 ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
138 mysql: [Warning] Using a password on the command line interface can be insecure.
139 CURRENT_USER()
140 arthurdent@localhost
141 mysql: [Warning] Using a password on the command line interface can be insecure.
142 CURRENT_USER()
143 arthurdent@localhost
144 mysql: [Warning] Using a password on the command line interface can be insecure.
145 CURRENT_USER()
146 arthurdent@localhost
147 mysql: [Warning] Using a password on the command line interface can be insecure.
148 CURRENT_USER()
149 arthurdent@localhost
150 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
151 SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
152 mysql: [Warning] Using a password on the command line interface can be insecure.
153 CURRENT_USER()
154 arthurdent@localhost
155 mysql: [Warning] Using a password on the command line interface can be insecure.
156 CURRENT_USER()
157 arthurdent@localhost
158 mysql: [Warning] Using a password on the command line interface can be insecure.
159 CURRENT_USER()
160 arthurdent@localhost
161 mysql: [Warning] Using a password on the command line interface can be insecure.
162 CURRENT_USER()
163 arthurdent@localhost
164 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
165 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
166 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
167 ALTER USER arthurdent@localhost PASSWORD EXPIRE;
168 mysql: [Warning] Using a password on the command line interface can be insecure.
169 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
170 mysql: [Warning] Using a password on the command line interface can be insecure.
171 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
172 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
173 GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
174 mysql: [Warning] Using a password on the command line interface can be insecure.
175 mysql: [Warning] Using a password on the command line interface can be insecure.
176 1
177 1
178 mysql: [Warning] Using a password on the command line interface can be insecure.
179 mysql: [Warning] Using a password on the command line interface can be insecure.
180 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
181 mysql: [Warning] Using a password on the command line interface can be insecure.
182 1
183 1
184 #-----------------------------------------------------------------------
185 # Cleanup
186 DROP USER arthurdent@localhost;
187 #-----------------------------------------------------------------------
188 #-----------------------------------------------------------------------
189 # Setup : Create users
190 CREATE USER arthurdent@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
191 #-----------------------------------------------------------------------
192 # Second password tests
193 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
194 mysql: [Warning] Using a password on the command line interface can be insecure.
195 CURRENT_USER()
196 arthurdent@localhost
197 mysql: [Warning] Using a password on the command line interface can be insecure.
198 CURRENT_USER()
199 arthurdent@localhost
200 mysql: [Warning] Using a password on the command line interface can be insecure.
201 CURRENT_USER()
202 arthurdent@localhost
203 mysql: [Warning] Using a password on the command line interface can be insecure.
204 CURRENT_USER()
205 arthurdent@localhost
206 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
207 mysql: [Warning] Using a password on the command line interface can be insecure.
208 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
209 mysql: [Warning] Using a password on the command line interface can be insecure.
210 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
211 mysql: [Warning] Using a password on the command line interface can be insecure.
212 CURRENT_USER()
213 arthurdent@localhost
214 mysql: [Warning] Using a password on the command line interface can be insecure.
215 CURRENT_USER()
216 arthurdent@localhost
217 ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
218 mysql: [Warning] Using a password on the command line interface can be insecure.
219 CURRENT_USER()
220 arthurdent@localhost
221 mysql: [Warning] Using a password on the command line interface can be insecure.
222 CURRENT_USER()
223 arthurdent@localhost
224 mysql: [Warning] Using a password on the command line interface can be insecure.
225 CURRENT_USER()
226 arthurdent@localhost
227 mysql: [Warning] Using a password on the command line interface can be insecure.
228 CURRENT_USER()
229 arthurdent@localhost
230 ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
231 mysql: [Warning] Using a password on the command line interface can be insecure.
232 CURRENT_USER()
233 arthurdent@localhost
234 mysql: [Warning] Using a password on the command line interface can be insecure.
235 CURRENT_USER()
236 arthurdent@localhost
237 mysql: [Warning] Using a password on the command line interface can be insecure.
238 CURRENT_USER()
239 arthurdent@localhost
240 mysql: [Warning] Using a password on the command line interface can be insecure.
241 CURRENT_USER()
242 arthurdent@localhost
243 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
244 SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
245 mysql: [Warning] Using a password on the command line interface can be insecure.
246 CURRENT_USER()
247 arthurdent@localhost
248 mysql: [Warning] Using a password on the command line interface can be insecure.
249 CURRENT_USER()
250 arthurdent@localhost
251 mysql: [Warning] Using a password on the command line interface can be insecure.
252 CURRENT_USER()
253 arthurdent@localhost
254 mysql: [Warning] Using a password on the command line interface can be insecure.
255 CURRENT_USER()
256 arthurdent@localhost
257 ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
258 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
259 ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
260 ALTER USER arthurdent@localhost PASSWORD EXPIRE;
261 mysql: [Warning] Using a password on the command line interface can be insecure.
262 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
263 mysql: [Warning] Using a password on the command line interface can be insecure.
264 ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
265 ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
266 GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
267 mysql: [Warning] Using a password on the command line interface can be insecure.
268 mysql: [Warning] Using a password on the command line interface can be insecure.
269 1
270 1
271 mysql: [Warning] Using a password on the command line interface can be insecure.
272 mysql: [Warning] Using a password on the command line interface can be insecure.
273 ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
274 mysql: [Warning] Using a password on the command line interface can be insecure.
275 1
276 1
277 #-----------------------------------------------------------------------
278 # Cleanup
279 DROP USER arthurdent@localhost;
280 #-----------------------------------------------------------------------
281 #-----------------------------------------------------------------------
282 #-----------------------------------------------------------------------