← Back to branch summary

~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-04-16 20:07:10 UTC
  • mto: (1.3.9 vivid-proposed)
  • mto: This revision was merged to the branch mainline in revision 11.
  • Revision ID: package-import@ubuntu.com-20150416200710-pcrsa022082zj46k
Tags: upstream-5.6.24
Import upstream version 5.6.24

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result
34
34
SHOW processlist;
35
35
Id      User    Host    db      Command Time    State   Info
36
36
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
37
 
ID      root    HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
37
ID      root    HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
38
38
SELECT * FROM processlist  ORDER BY id;
39
39
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
 
40
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
40
41
ID      root    HOST_NAME       information_schema      Query   TIME    executing       SELECT * FROM processlist  ORDER BY id
41
 
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
42
42
SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id;
43
43
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
 
44
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
44
45
ID      root    HOST_NAME       information_schema      Query   TIME    executing       SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id
45
 
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
46
46
CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
47
47
UPDATE test.t_processlist SET user='horst' WHERE id=1  ;
48
48
INSERT INTO processlist SELECT * FROM test.t_processlist;
104
104
) ENGINE=MyISAM DEFAULT CHARSET=utf8
105
105
SHOW processlist;
106
106
Id      User    Host    db      Command Time    State   Info
107
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
107
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
108
108
SELECT * FROM processlist  ORDER BY id;
109
109
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
110
110
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    executing       SELECT * FROM processlist  ORDER BY id
132
132
ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database 'information_schema'
133
133
SHOW GRANTS;
134
134
Grants for ddicttestuser1@localhost
135
 
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
135
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
136
136
CREATE INDEX i_processlist ON processlist (user);
137
137
ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database 'information_schema'
138
138
DROP TABLE processlist;
166
166
####################################################################################
167
167
SHOW GRANTS;
168
168
Grants for ddicttestuser1@localhost
169
 
GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
169
GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
170
170
SHOW processlist;
171
171
Id      User    Host    db      Command Time    State   Info
172
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
172
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
173
173
SELECT * FROM information_schema.processlist;
174
174
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
175
175
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    executing       SELECT * FROM information_schema.processlist
179
179
####################################################################################
180
180
SHOW GRANTS;
181
181
Grants for ddicttestuser1@localhost
182
 
GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
182
GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
183
183
SHOW processlist;
184
184
Id      User    Host    db      Command Time    State   Info
185
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
185
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
186
186
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
187
187
ID      root    HOST_NAME       information_schema      Sleep   TIME            NULL
188
188
SELECT * FROM information_schema.processlist;
205
205
GRANT PROCESS ON *.* TO ''@'localhost'
206
206
SHOW processlist;
207
207
Id      User    Host    db      Command Time    State   Info
208
 
ID              HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
208
ID              HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
209
209
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
210
210
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
211
211
ID      root    HOST_NAME       information_schema      Sleep   TIME            NULL
227
227
####################################################################################
228
228
SHOW GRANTS;
229
229
Grants for ddicttestuser1@localhost
230
 
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
230
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
231
231
SHOW processlist;
232
232
Id      User    Host    db      Command Time    State   Info
233
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
233
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
234
234
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
235
235
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
236
236
SELECT * FROM information_schema.processlist;
269
269
GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
270
270
SHOW processlist;
271
271
Id      User    Host    db      Command Time    State   Info
272
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
272
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
273
273
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
274
274
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
275
275
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
291
291
####################################################################################
292
292
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
293
293
Grants for ddicttestuser1@localhost
294
 
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
294
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
295
295
SHOW processlist;
296
296
Id      User    Host    db      Command Time    State   Info
297
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
297
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
298
298
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
299
299
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
300
300
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
339
339
####################################################################################
340
340
SHOW GRANTS FOR 'ddicttestuser2'@'localhost';
341
341
Grants for ddicttestuser2@localhost
342
 
GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
342
GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD
343
343
SHOW processlist;
344
344
Id      User    Host    db      Command Time    State   Info
345
345
ID              HOST_NAME       information_schema      Sleep   TIME            NULL
351
351
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
352
352
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
353
353
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
354
 
ID      ddicttestuser2  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
354
ID      ddicttestuser2  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
355
355
ID      root    HOST_NAME       information_schema      Sleep   TIME            NULL
356
356
SELECT * FROM information_schema.processlist;
357
357
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
377
377
####################################################################################
378
378
SHOW GRANTS;
379
379
Grants for ddicttestuser2@localhost
380
 
GRANT USAGE ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
380
GRANT USAGE ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD
381
381
SHOW processlist;
382
382
Id      User    Host    db      Command Time    State   Info
383
 
ID      ddicttestuser2  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
383
ID      ddicttestuser2  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
384
384
ID      ddicttestuser2  HOST_NAME       information_schema      Sleep   TIME            NULL
385
385
SELECT * FROM information_schema.processlist;
386
386
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
398
398
####################################################################################
399
399
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
400
400
Grants for ddicttestuser1@localhost
401
 
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
401
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
402
402
GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
403
403
ERROR 28000: Access denied for user 'ddicttestuser1'@'localhost' (using password: YES)
404
404
SHOW processlist;
405
405
Id      User    Host    db      Command Time    State   Info
406
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
406
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
407
407
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
408
408
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
409
409
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
435
435
####################################################################################
436
436
SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
437
437
Grants for ddicttestuser1@localhost
438
 
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 
438
GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD
439
439
SHOW processlist;
440
440
Id      User    Host    db      Command Time    State   Info
441
 
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    init    SHOW processlist
 
441
ID      ddicttestuser1  HOST_NAME       information_schema      Query   TIME    STATE   SHOW processlist
442
442
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
443
443
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL
444
444
ID      ddicttestuser1  HOST_NAME       information_schema      Sleep   TIME            NULL