Debian Codegraph @

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

raw
1 # Check with caching_sha2_password as --default-authentication-plugin
2 # Restart the server with caching_sha2_password as default authnetication plugin
3 # Create users
4 CREATE USER caching_sha2@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
5 CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
6 CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
7 # Connection tests
8 mysql: [Warning] Using a password on the command line interface can be insecure.
9 CURRENT_USER()
10 caching_sha2@localhost
11 mysql: [Warning] Using a password on the command line interface can be insecure.
12 CURRENT_USER()
13 caching_sha2@localhost
14 mysql: [Warning] Using a password on the command line interface can be insecure.
15 CURRENT_USER()
16 caching_sha2@localhost
17 FLUSH PRIVILEGES;
18 mysql: [Warning] Using a password on the command line interface can be insecure.
19 CURRENT_USER()
20 caching_sha2@localhost
21 FLUSH PRIVILEGES;
22 mysql: [Warning] Using a password on the command line interface can be insecure.
23 CURRENT_USER()
24 caching_sha2@localhost
25 FLUSH PRIVILEGES;
26 mysql: [Warning] Using a password on the command line interface can be insecure.
27 CURRENT_USER()
28 caching_sha2@localhost
29 FLUSH PRIVILEGES;
30 mysql: [Warning] Using a password on the command line interface can be insecure.
31 CURRENT_USER()
32 native@localhost
33 mysql: [Warning] Using a password on the command line interface can be insecure.
34 CURRENT_USER()
35 native@localhost
36 mysql: [Warning] Using a password on the command line interface can be insecure.
37 CURRENT_USER()
38 native@localhost
39 FLUSH PRIVILEGES;
40 mysql: [Warning] Using a password on the command line interface can be insecure.
41 CURRENT_USER()
42 sha256@localhost
43 mysql: [Warning] Using a password on the command line interface can be insecure.
44 CURRENT_USER()
45 sha256@localhost
46 mysql: [Warning] Using a password on the command line interface can be insecure.
47 CURRENT_USER()
48 sha256@localhost
49 FLUSH PRIVILEGES;
50 # Change user tests
51 SELECT CURRENT_USER();
52 CURRENT_USER()
53 native@localhost
54 SELECT CURRENT_USER();
55 CURRENT_USER()
56 sha256@localhost
57 SELECT CURRENT_USER();
58 CURRENT_USER()
59 sha256@localhost
60 SELECT CURRENT_USER();
61 CURRENT_USER()
62 caching_sha2@localhost
63 SELECT CURRENT_USER();
64 CURRENT_USER()
65 sha256@localhost
66 SELECT CURRENT_USER();
67 CURRENT_USER()
68 sha256@localhost
69 SELECT CURRENT_USER();
70 CURRENT_USER()
71 caching_sha2@localhost
72 SELECT CURRENT_USER();
73 CURRENT_USER()
74 native@localhost
75 SELECT CURRENT_USER();
76 CURRENT_USER()
77 native@localhost
78 # Drop users
79 DROP USER caching_sha2@localhost;
80 DROP USER native@localhost;
81 DROP USER sha256@localhost;
82 # Check with mysql_native_password as --default-authentication-plugin
83 # Restart the server with mysql_native_password as default authnetication plugin
84 # Create users
85 CREATE USER caching_sha2@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
86 CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
87 CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
88 # Connection tests
89 mysql: [Warning] Using a password on the command line interface can be insecure.
90 CURRENT_USER()
91 caching_sha2@localhost
92 mysql: [Warning] Using a password on the command line interface can be insecure.
93 CURRENT_USER()
94 caching_sha2@localhost
95 mysql: [Warning] Using a password on the command line interface can be insecure.
96 CURRENT_USER()
97 caching_sha2@localhost
98 FLUSH PRIVILEGES;
99 mysql: [Warning] Using a password on the command line interface can be insecure.
100 CURRENT_USER()
101 caching_sha2@localhost
102 FLUSH PRIVILEGES;
103 mysql: [Warning] Using a password on the command line interface can be insecure.
104 CURRENT_USER()
105 caching_sha2@localhost
106 FLUSH PRIVILEGES;
107 mysql: [Warning] Using a password on the command line interface can be insecure.
108 CURRENT_USER()
109 caching_sha2@localhost
110 FLUSH PRIVILEGES;
111 mysql: [Warning] Using a password on the command line interface can be insecure.
112 CURRENT_USER()
113 native@localhost
114 mysql: [Warning] Using a password on the command line interface can be insecure.
115 CURRENT_USER()
116 native@localhost
117 mysql: [Warning] Using a password on the command line interface can be insecure.
118 CURRENT_USER()
119 native@localhost
120 FLUSH PRIVILEGES;
121 mysql: [Warning] Using a password on the command line interface can be insecure.
122 CURRENT_USER()
123 sha256@localhost
124 mysql: [Warning] Using a password on the command line interface can be insecure.
125 CURRENT_USER()
126 sha256@localhost
127 mysql: [Warning] Using a password on the command line interface can be insecure.
128 CURRENT_USER()
129 sha256@localhost
130 FLUSH PRIVILEGES;
131 # Change user tests
132 SELECT CURRENT_USER();
133 CURRENT_USER()
134 native@localhost
135 SELECT CURRENT_USER();
136 CURRENT_USER()
137 sha256@localhost
138 SELECT CURRENT_USER();
139 CURRENT_USER()
140 sha256@localhost
141 SELECT CURRENT_USER();
142 CURRENT_USER()
143 caching_sha2@localhost
144 SELECT CURRENT_USER();
145 CURRENT_USER()
146 sha256@localhost
147 SELECT CURRENT_USER();
148 CURRENT_USER()
149 sha256@localhost
150 SELECT CURRENT_USER();
151 CURRENT_USER()
152 caching_sha2@localhost
153 SELECT CURRENT_USER();
154 CURRENT_USER()
155 native@localhost
156 SELECT CURRENT_USER();
157 CURRENT_USER()
158 native@localhost
159 # Drop users
160 DROP USER caching_sha2@localhost;
161 DROP USER native@localhost;
162 DROP USER sha256@localhost;
163 # Check with sha256_password as --default-authentication-plugin
164 # Restart the server with sha256_password as default authnetication plugin
165 # Create users
166 CREATE USER caching_sha2@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
167 CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
168 CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
169 # Connection tests
170 mysql: [Warning] Using a password on the command line interface can be insecure.
171 CURRENT_USER()
172 caching_sha2@localhost
173 mysql: [Warning] Using a password on the command line interface can be insecure.
174 CURRENT_USER()
175 caching_sha2@localhost
176 mysql: [Warning] Using a password on the command line interface can be insecure.
177 CURRENT_USER()
178 caching_sha2@localhost
179 FLUSH PRIVILEGES;
180 mysql: [Warning] Using a password on the command line interface can be insecure.
181 CURRENT_USER()
182 caching_sha2@localhost
183 FLUSH PRIVILEGES;
184 mysql: [Warning] Using a password on the command line interface can be insecure.
185 CURRENT_USER()
186 caching_sha2@localhost
187 FLUSH PRIVILEGES;
188 mysql: [Warning] Using a password on the command line interface can be insecure.
189 CURRENT_USER()
190 caching_sha2@localhost
191 FLUSH PRIVILEGES;
192 mysql: [Warning] Using a password on the command line interface can be insecure.
193 CURRENT_USER()
194 native@localhost
195 mysql: [Warning] Using a password on the command line interface can be insecure.
196 CURRENT_USER()
197 native@localhost
198 mysql: [Warning] Using a password on the command line interface can be insecure.
199 CURRENT_USER()
200 native@localhost
201 FLUSH PRIVILEGES;
202 mysql: [Warning] Using a password on the command line interface can be insecure.
203 CURRENT_USER()
204 sha256@localhost
205 mysql: [Warning] Using a password on the command line interface can be insecure.
206 CURRENT_USER()
207 sha256@localhost
208 mysql: [Warning] Using a password on the command line interface can be insecure.
209 CURRENT_USER()
210 sha256@localhost
211 FLUSH PRIVILEGES;
212 # Change user tests
213 SELECT CURRENT_USER();
214 CURRENT_USER()
215 native@localhost
216 SELECT CURRENT_USER();
217 CURRENT_USER()
218 sha256@localhost
219 SELECT CURRENT_USER();
220 CURRENT_USER()
221 sha256@localhost
222 SELECT CURRENT_USER();
223 CURRENT_USER()
224 caching_sha2@localhost
225 SELECT CURRENT_USER();
226 CURRENT_USER()
227 sha256@localhost
228 SELECT CURRENT_USER();
229 CURRENT_USER()
230 sha256@localhost
231 SELECT CURRENT_USER();
232 CURRENT_USER()
233 caching_sha2@localhost
234 SELECT CURRENT_USER();
235 CURRENT_USER()
236 native@localhost
237 SELECT CURRENT_USER();
238 CURRENT_USER()
239 native@localhost
240 # Drop users
241 DROP USER caching_sha2@localhost;
242 DROP USER native@localhost;
243 DROP USER sha256@localhost;