Debian Codegraph @

mysql-test/suite/funcs_1/datadict/processlist_priv.inc

raw
1 ############ suite/funcs_1/datadict/processlist_priv.inc ###############
2 # #
3 # Testing of privileges around #
4 # SELECT ... PROCESSLIST/SHOW PROCESSLIST #
5 # #
6 # Note(mleich): #
7 # There is a significant risk to get an unstable test because of #
8 # timing issues. #
9 # Example1: #
10 # 1. Disconnect connection X #
11 # 2. Switch to connection Y #
12 # 3. SHOW PROCESSLIST might present a record like #
13 # <ID> <user> <host> <db> Quit 0 cleaning up NULL #
14 # or even a row where connection X is without #
15 # "Quit" or "cleaning up". #
16 # That means our SHOW PROCESSLIST can come too early. #
17 # Solution: #
18 # Close the connections at the end of the test. #
19 # Example2 (2008-08-14 again observed): #
20 # 1. connection X: SHOW PROCESSLIST/GRANT ... etc. #
21 # 2. Switch to connection Y #
22 # 3. SHOW PROCESSLIST might present a record like #
23 # <ID> <user> <host> <db> Query TIME cleaning up <command> #
24 # <ID> <user> <host> <db> Query TIME writing to net <command> #
25 # Problems happens more often in case of slow filesystem! #
26 # First Solution: #
27 # Insert a dummy SQL command where the cleanup is most probably #
28 # fast before switching to another connection and running #
29 # SHOW/SELECT PROCESSLIST. #
30 # Suppress writing to protocol by assignment to $variable. #
31 # let $my_var= `SELECT 1`; #
32 # Even the 'SELECT 1' was in some cases in state #
33 # "writing to net". #
34 # Final Solution: #
35 # --real_sleep 0.3 #
36 # This value was at least on my box sufficient. #
37 # Please inform us if this test fails so that we can adjust #
38 # the sleep time better or switch to poll routines. #
39 # #
40 # Storage engine variants of this test do not make sense. #
41 # - I_S tables use the MEMORY storage engine whenever possible. #
42 # - There are some I_S table which need column data types which #
43 # are not supported by MEMORY. Example: LONGTEXT/BLOB #
44 # MyISAM will be used for such tables. #
45 # The column PROCESSLIST.INFO is of data type LONGTEXT #
46 # ----> MyISAM #
47 # - There is no impact of the GLOBAL(server) or SESSION default #
48 # storage engine setting on the engine used for I_S tables. #
49 # #
50 # Creation: #
51 # 2007-08 hhunger Implement this test as part of #
52 # WL#3982 Test information_schema.processlist #
53 # #
54 # Last update: #
55 # 2008-08-14 mleich Bug#38270 Test "processlist_priv_ps" fails on #
56 # varying "processlist" output #
57 # - Replace one sleep by a poll routines #
58 # - Remove or disable superfluous sleeps #
59 # #
60 ########################################################################
61
62 # The following variables are used in "datadict_priv.inc" and here.
63 #
64 # information_schema table to be tested
65 let $table= processlist;
66 #
67 # columns of the information_schema table e.g. to use in a select.
68 let $columns= ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS, MEMORY_USED, EXAMINED_ROWS, QUERY_ID, INFO_BINARY;
69 #
70 # Where clause for an update.
71 let $update_where= WHERE id=1 ;
72 #
73 # Column to be used in the SET of an update.
74 let $set_column= user='any_user' ;
75 #
76 # Where clause of a delete.
77 let $delete_where= WHERE id=1 ;
78 #
79 # Column to be dropped.
80 let $drop_column= user;
81 #
82 # Column to be indexed
83 let $index_col= user;
84
85 USE information_schema;
86
87 --echo ####################################################################################
88 --echo 1 Prepare test.
89 --echo connection default (user=root)
90 --echo ####################################################################################
91
92 # Check that we have only one connection around.
93 # If there is more, it may be the check() connection that has not yet ended,
94 # so we wait for it for up to 10 seconds.
95
96 let $counter=100;
97 while ($counter)
98 {
99 dec $counter;
100 let $res= `SELECT COUNT(*) <> 1 FROM processlist`;
101 if (!$res)
102 {
103 # Success; Abort while loop
104 let $counter=0;
105 }
106 if ($res)
107 {
108 --sleep 0.1
109 if (!$counter)
110 {
111 --echo This test expects one connection to the server.
112 --echo Expectation: USER HOST DB COMMAND STATE INFO
113 --echo Expectation: root localhost information_schema Query executing SELECT USER,HOST,DB,COMMAND,STATE,INFO FROM processlist ORDER BY ID
114 --echo But we found in the moment:
115 SELECT USER,HOST,DB,COMMAND,STATE,INFO FROM processlist ORDER BY ID;
116 --echo Maybe
117 --echo - the base configuration (no of parallel auxiliary sessions) of the server has changed
118 --echo - a parallel test intended for another server accidently connected to our current one
119 --echo We cannot proceed in this situation. Abort
120 exit;
121 }
122 }
123 }
124
125 --echo ####################################################################################
126 --echo 1.1 Create two user
127 --echo ####################################################################################
128 # access to info tables as normal user
129 --error 0, ER_CANNOT_USER
130 DROP USER ddicttestuser1@'localhost';
131 --error 0, ER_CANNOT_USER
132 DROP USER ddicttestuser2@'localhost';
133 CREATE USER ddicttestuser1@'localhost';
134 CREATE USER ddicttestuser2@'localhost';
135 GRANT SELECT,UPDATE,DELETE,INSERT,CREATE,CREATE TEMPORARY TABLES,CREATE VIEW,DROP on test.* to ddicttestuser1@'localhost';
136 GRANT SELECT,UPDATE,DELETE,INSERT,CREATE,CREATE TEMPORARY TABLES,CREATE VIEW,DROP on test.* to ddicttestuser2@'localhost';
137 SET PASSWORD FOR ddicttestuser1@'localhost' = PASSWORD('ddictpass');
138 SET PASSWORD FOR ddicttestuser2@'localhost' = PASSWORD('ddictpass');
139
140 --echo ####################################################################################
141 --echo 1.2 Establish connection con100 (user=ddicttestuser1 with no PROCESS privilege):
142 connect (con100,localhost,ddicttestuser1,ddictpass,information_schema);
143 --echo ####################################################################################
144
145
146 --echo ####################################################################################
147 --echo 2 connection default(user=root with default privileges):
148 --echo SHOW/SELECT shows all processes/threads.
149 --echo ####################################################################################
150 connection default;
151 # Avoid Bug#38270 Test "processlist_priv_ps" fails on varying "processlist" output
152 # This subtest expects that the connection con100 is in state 'Sleep'.
153 # Poll till the connection con100 is in state COMMAND = 'Sleep'.
154 let $wait_timeout= 10;
155 let $wait_condition=
156 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST
157 WHERE DB = 'information_schema' AND COMMAND = 'Sleep' AND USER = 'ddicttestuser1' AND state='';
158 --source include/wait_condition.inc
159 --replace_result ENGINE=MyISAM "" ENGINE=Aria "" " PAGE_CHECKSUM=1" "" " PAGE_CHECKSUM=0" ""
160 eval SHOW CREATE TABLE $table;
161 --replace_result Execute Query
162 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
163 eval SHOW $table;
164 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
165 eval SELECT * FROM $table $select_where ORDER BY id;
166 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 ROWS 15 QUERY_ID 17 TID
167 eval SELECT $columns FROM $table $select_where ORDER BY id;
168 --source suite/funcs_1/datadict/datadict_priv.inc
169 --real_sleep 0.3
170
171
172 --echo ####################################################################################
173 --echo 3 Switch to connection con100 (user=ddicttestuser1 with no PROCESS privilege):
174 connection con100;
175 --echo SHOW/SELECT shows only the processes (1) of the user.
176 --echo ####################################################################################
177 # No need for poll routine here.
178 # The current state of the default session might depend on load of testing box
179 # but "ddicttestuser1" must not see anything of the root session.
180 --replace_result ENGINE=MyISAM "" ENGINE=Aria "" " PAGE_CHECKSUM=1" "" " PAGE_CHECKSUM=0" ""
181 eval SHOW CREATE TABLE $table;
182 --replace_result Execute Query
183 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
184 eval SHOW $table;
185 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
186 eval SELECT * FROM $table $select_where ORDER BY id;
187 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 ROWS 15 QUERY_ID 17 TID
188 eval SELECT $columns FROM $table $select_where ORDER BY id;
189 --source suite/funcs_1/datadict/datadict_priv.inc
190 --real_sleep 0.3
191
192
193 --echo ####################################################################################
194 --echo 4 Grant PROCESS privilege to ddicttestuser1
195 --echo connection default (user=root)
196 --echo ####################################################################################
197 connection default;
198 GRANT PROCESS ON *.* TO ddicttestuser1@'localhost' IDENTIFIED BY 'ddictpass';
199 --real_sleep 0.3
200
201 --echo ####################################################################################
202 --echo 4.1 Existing connection con100 (ddicttestuser1)
203 --echo The user ddicttestuser1 has the PROCESS privilege, but the connection was
204 --echo established before PROCESS was granted.
205 --echo SHOW/SELECT shows only the processes (1) of the user.
206 --echo ####################################################################################
207 connection con100;
208 SHOW GRANTS;
209 --replace_result Execute Query
210 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
211 SHOW processlist;
212 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
213 SELECT * FROM information_schema.processlist;
214 --real_sleep 0.3
215
216 --echo ####################################################################################
217 --echo 4.2 New connection con101 (ddicttestuser1 with PROCESS privilege)
218 --echo SHOW/SELECT shows all processes/threads.
219 --echo ####################################################################################
220 connect (con101,localhost,ddicttestuser1,ddictpass,information_schema);
221 SHOW GRANTS;
222 --replace_result Execute Query
223 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
224 SHOW processlist;
225 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
226 SELECT * FROM information_schema.processlist;
227 --real_sleep 0.3
228
229
230 --echo ####################################################################################
231 --echo 5 Grant PROCESS privilege to anonymous user.
232 --echo connection default (user=root)
233 --echo ####################################################################################
234 connection default;
235 create user ''@'localhost';
236 GRANT PROCESS ON *.* TO ''@'localhost';
237 --real_sleep 0.3
238
239 --echo ####################################################################################
240 --echo 5.1 Establish connection (anonymous1,localhost,'',,information_schema)
241 --echo anonymous user with PROCESS privilege
242 --echo SHOW/SELECT shows all processes/threads.
243 --echo ####################################################################################
244 connect (anonymous1,localhost,"''",,information_schema);
245 SHOW GRANTS;
246 --replace_result Execute Query
247 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
248 SHOW processlist;
249 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
250 SELECT * FROM information_schema.processlist;
251 --real_sleep 0.3
252
253
254 --echo ####################################################################################
255 --echo 6 Revoke PROCESS privilege from ddicttestuser1
256 --echo connection default (user=root)
257 --echo ####################################################################################
258 connection default;
259 REVOKE PROCESS ON *.* FROM ddicttestuser1@'localhost';
260 --real_sleep 0.3
261
262 --echo ####################################################################################
263 --echo 6.1 New connection con102 (ddicttestuser1 has no more PROCESS privilege)
264 connect (con102,localhost,ddicttestuser1,ddictpass,information_schema);
265 --echo Again (compared to state before GRANT PROCESS) only the processes of
266 --echo ddicttestuser1 are visible.
267 --echo ####################################################################################
268 SHOW GRANTS;
269 --replace_result Execute Query
270 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
271 SHOW processlist;
272 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
273 SELECT * FROM information_schema.processlist;
274 --real_sleep 0.3
275
276
277 --echo ####################################################################################
278 --echo 7 Revoke PROCESS privilege from anonymous user
279 --echo connection default (user=root)
280 --echo ####################################################################################
281 connection default;
282 REVOKE PROCESS ON *.* FROM ''@'localhost';
283 --real_sleep 0.3
284
285 --echo ####################################################################################
286 --echo 7.1 New connection (anonymous2,localhost,'',,information_schema)
287 connect (anonymous2,localhost,"''",,information_schema);
288 --echo The anonymous user has no more the PROCESS privilege
289 --echo Again only the processes of the anonymous user are visible.
290 --echo ####################################################################################
291 SHOW GRANTS FOR ''@'localhost';
292 if ($fixed_bug_30395)
293 {
294 # Bug#30395 strange results after REVOKE PROCESS ON *.* FROM ...
295 --replace_result Execute Query
296 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
297 SHOW processlist;
298 }
299 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
300 SELECT * FROM information_schema.processlist;
301 --real_sleep 0.3
302
303
304 --echo ####################################################################################
305 --echo 8 Grant SUPER (does not imply PROCESS) privilege to ddicttestuser1
306 --echo connection default (user=root)
307 --echo ####################################################################################
308 connection default;
309 GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost';
310 --real_sleep 0.3
311
312 --echo ####################################################################################
313 --echo 8.1 New connection con103 (ddicttestuser1 with SUPER privilege)
314 connect (con103,localhost,ddicttestuser1,ddictpass,information_schema);
315 --echo Only the processes of ddicttestuser1 user are visible.
316 --echo ####################################################################################
317 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
318 --replace_result Execute Query
319 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
320 SHOW processlist;
321 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
322 SELECT * FROM information_schema.processlist;
323 --real_sleep 0.3
324
325
326 --echo ####################################################################################
327 --echo 9 Revoke SUPER privilege from user ddicttestuser1
328 --echo connection default (user=root)
329 --echo ####################################################################################
330 connection default;
331 REVOKE SUPER ON *.* FROM 'ddicttestuser1'@'localhost';
332 --real_sleep 0.3
333
334 --echo ####################################################################################
335 --echo 9.1 New connection con104 (ddicttestuser1 without SUPER privilege)
336 connect (con104,localhost,ddicttestuser1,ddictpass,information_schema);
337 --echo ddicttestuser1 has no more the SUPER privilege.
338 --echo Only the processes of ddicttestuser1 are visible.
339 --echo ####################################################################################
340 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
341 --replace_result Execute Query
342 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
343 SHOW processlist;
344 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
345 SELECT * FROM information_schema.processlist;
346 --real_sleep 0.3
347
348
349 --echo ####################################################################################
350 --echo 10 Grant SUPER privilege with grant option to user ddicttestuser1.
351 --echo connection default (user=root)
352 --echo ####################################################################################
353 connection default;
354 GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' WITH GRANT OPTION;
355 --real_sleep 0.3
356
357 --echo ####################################################################################
358 --echo 10.1 New connection con105 (ddicttestuser1 with SUPER privilege and GRANT OPTION)
359 connect (con105,localhost,ddicttestuser1,ddictpass,information_schema);
360 --echo Try to grant PROCESS privilege to user ddicttestuser2 without having it.
361 --echo ####################################################################################
362 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
363 --error ER_ACCESS_DENIED_ERROR
364 GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
365
366 --echo ####################################################################################
367 --echo 10.2 Grant SUPER and PROCESS privilege with grant option to user ddicttestuser1
368 --echo connection default (user=root)
369 --echo ####################################################################################
370 connection default;
371 GRANT SUPER,PROCESS ON *.* TO 'ddicttestuser1'@'localhost' WITH GRANT OPTION;
372 --real_sleep 0.3
373
374 --echo ####################################################################################
375 --echo 10.3 New connection con106 (ddicttestuser1 with SUPER,PROCESS WITH GRANT OPTION)
376 connect (con106,localhost,ddicttestuser1,ddictpass,information_schema);
377 --echo Grant PROCESS privilege to user ddicttestuser2
378 --echo ####################################################################################
379 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
380 GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
381 --real_sleep 0.3
382
383 --echo ####################################################################################
384 --echo 10.4 New connection con200 (ddicttestuser2 with PROCESS privilege)
385 connect (con200,localhost,ddicttestuser2,ddictpass,information_schema);
386 --echo ddicttestuser2 has now the PROCESS privilege and sees all connections
387 --echo ####################################################################################
388 SHOW GRANTS FOR 'ddicttestuser2'@'localhost';
389 --replace_result Execute Query
390 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
391 SHOW processlist;
392 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
393 SELECT * FROM information_schema.processlist;
394 --real_sleep 0.3
395
396
397 --echo ####################################################################################
398 --echo 11 User ddicttestuser1 revokes PROCESS privilege from user ddicttestuser2
399 --echo connection ddicttestuser1;
400 --echo ####################################################################################
401 connection con106;
402 REVOKE PROCESS ON *.* FROM 'ddicttestuser2'@'localhost';
403 --real_sleep 0.3
404
405 --echo ####################################################################################
406 --echo 11.1 New connection con201 (ddicttestuser2)
407 connect (con201,localhost,ddicttestuser2,ddictpass,information_schema);
408 --echo ddicttestuser2 has no more the PROCESS privilege and can only see own connects
409 --echo ####################################################################################
410 SHOW GRANTS;
411 --replace_result Execute Query
412 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
413 SHOW processlist;
414 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
415 SELECT * FROM information_schema.processlist;
416 --real_sleep 0.3
417
418 --echo ####################################################################################
419 --echo 11.2 Revoke SUPER,PROCESS,GRANT OPTION privilege from user ddicttestuser1
420 --echo connection default (user=root)
421 --echo ####################################################################################
422 connection default;
423 REVOKE SUPER,PROCESS,GRANT OPTION ON *.* FROM 'ddicttestuser1'@'localhost';
424 --real_sleep 0.3
425
426 --echo ####################################################################################
427 --echo 11.3 New connection con107 (ddicttestuser1)
428 connect (con107,localhost,ddicttestuser1,ddictpass,information_schema);
429 --echo ddicttestuser1 has no more the PROCESS privilege and can only see own connects
430 --echo He is also unable to GRANT the PROCESS privilege to ddicttestuser2
431 --echo ####################################################################################
432 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
433 --error ER_ACCESS_DENIED_ERROR
434 GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
435 --replace_result Execute Query
436 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
437 SHOW processlist;
438 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
439 SELECT * FROM information_schema.processlist;
440 --real_sleep 0.3
441
442
443 --echo ####################################################################################
444 --echo 12 Revoke the SELECT privilege from user ddicttestuser1
445 --echo connection default (user=root)
446 --echo ####################################################################################
447 connection default;
448 REVOKE SELECT ON *.* FROM 'ddicttestuser1'@'localhost';
449 --real_sleep 0.3
450
451 --echo ####################################################################################
452 --echo 12.1 New connection con108 (ddicttestuser1)
453 connect (con108,localhost,ddicttestuser1,ddictpass,information_schema);
454 --echo ddicttestuser1 has neither PROCESS nor SELECT privilege
455 --echo Manual says: Each MySQL user has the right to access these tables, but can see
456 --echo only the rows ...
457 --echo Therefore the missing SELECT privilege does not affect SELECTs on PROCESSLIST.
458 --echo ####################################################################################
459 SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
460 --replace_result Execute Query
461 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
462 SHOW processlist;
463 --replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS 13 MEMORY 14 MAX_MEMORY 15 E_ROWS 16 S_ROWS 17 QUERY_ID 19 TID
464 SELECT * FROM information_schema.processlist;
465 --real_sleep 0.3
466
467 --echo ####################################################################################
468 --echo 12.2 Revoke only the SELECT privilege on the information_schema from ddicttestuser1.
469 --echo connection default (user=root)
470 --echo ####################################################################################
471 connection default;
472 --error ER_DBACCESS_DENIED_ERROR
473 REVOKE SELECT ON information_schema.* FROM 'ddicttestuser3'@'localhost';
474 --real_sleep 0.3
475
476
477 --echo ####################################################################################
478 --echo connection default (user=root)
479 --echo Cleanup: close connections, DROP USER etc.
480 --echo ####################################################################################
481 connection default;
482 disconnect con100;
483 disconnect con101;
484 disconnect con102;
485 disconnect con103;
486 disconnect con104;
487 disconnect con105;
488 disconnect con106;
489 disconnect con107;
490 disconnect con108;
491 disconnect con200;
492 disconnect con201;
493 disconnect anonymous1;
494 disconnect anonymous2;
495 DROP USER ddicttestuser1@'localhost';
496 DROP USER ddicttestuser2@'localhost';
497 REVOKE USAGE ON *.* FROM ''@'localhost';
498 DROP USER ''@'localhost';