163
164
Warning 1364 Field 'ssl_cipher' doesn't have a default value
164
165
Warning 1364 Field 'x509_issuer' doesn't have a default value
165
166
Warning 1364 Field 'x509_subject' doesn't have a default value
166
insert into mysql.db (host, db, user, select_priv) values
167
insert into mysql.db (host, db, user, select_priv) values
167
168
('localhost', 'a%', 'test11', 'Y'), ('localhost', 'ab%', 'test11', 'Y');
168
169
alter table mysql.db order by db asc;
169
170
flush privileges;
264
265
CREATE DATABASE ��;
266
CREATE TABLE ��� (��� int);
267
CREATE TABLE ��� (��� INT);
267
268
GRANT SELECT ON ��.* TO ����@localhost;
268
269
SHOW GRANTS FOR ����@localhost;
269
270
Grants for ����@localhost
382
383
grant select (b) on mysqltest_1.t2 to mysqltest_3@localhost;
383
384
grant select (c) on mysqltest_2.t1 to mysqltest_3@localhost;
384
385
grant update (d) on mysqltest_2.t2 to mysqltest_3@localhost;
385
SELECT * FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES
386
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
387
ORDER BY TABLE_NAME,COLUMN_NAME,PRIVILEGE_TYPE;
386
SELECT * FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES
387
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
388
ORDER BY TABLE_NAME,COLUMN_NAME,PRIVILEGE_TYPE;
388
389
GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
389
390
'mysqltest_3'@'localhost' NULL mysqltest_1 t1 a UPDATE NO
390
391
'mysqltest_3'@'localhost' NULL mysqltest_2 t1 c SELECT NO
391
392
'mysqltest_3'@'localhost' NULL mysqltest_1 t2 b SELECT NO
392
393
'mysqltest_3'@'localhost' NULL mysqltest_2 t2 d UPDATE NO
393
394
SELECT * FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
394
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
395
ORDER BY TABLE_NAME,PRIVILEGE_TYPE;
395
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
396
ORDER BY TABLE_NAME,PRIVILEGE_TYPE;
396
397
GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE
397
398
SELECT * from INFORMATION_SCHEMA.SCHEMA_PRIVILEGES
398
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
399
ORDER BY TABLE_SCHEMA,PRIVILEGE_TYPE;
399
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
400
ORDER BY TABLE_SCHEMA,PRIVILEGE_TYPE;
400
401
GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
401
402
SELECT * from INFORMATION_SCHEMA.USER_PRIVILEGES
402
403
WHERE GRANTEE = '''mysqltest_3''@''localhost'''
458
459
Alter Tables To alter the table
459
460
Alter routine Functions,Procedures To alter or drop stored functions/procedures
460
461
Create Databases,Tables,Indexes To create new databases and tables
461
Create routine Functions,Procedures To use CREATE FUNCTION/PROCEDURE
462
Create routine Databases To use CREATE FUNCTION/PROCEDURE
462
463
Create temporary tables Databases To use CREATE TEMPORARY TABLE
463
464
Create view Tables To create new views
464
465
Create user Server Admin To create new users
885
886
CREATE DATABASE mysqltest3;
887
888
CREATE TABLE t_nn (c1 INT);
888
889
CREATE VIEW v_nn AS SELECT * FROM t_nn;
889
890
CREATE DATABASE mysqltest2;
891
892
CREATE TABLE t_nn (c1 INT);
892
893
CREATE VIEW v_nn AS SELECT * FROM t_nn;
893
894
CREATE VIEW v_yn AS SELECT * FROM t_nn;
957
958
DROP DATABASE mysqltest3;
958
959
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'mysqltest_1'@'localhost';
959
960
DROP USER 'mysqltest_1'@'localhost';
961
962
create user mysqltest1_thisisreallytoolong;
962
963
ERROR HY000: String 'mysqltest1_thisisreallytoolong' is too long for user name (should be no longer than 16)
963
964
CREATE DATABASE mysqltest1;
1195
1196
DROP DATABASE mysqltest2;
1196
1197
DROP USER mysqltest_1@localhost;
1197
1198
DROP USER mysqltest_2@localhost;
1199
1200
CREATE TABLE t1 (f1 int, f2 int);
1200
1201
INSERT INTO t1 VALUES(1,1), (2,2);
1201
1202
CREATE DATABASE db27878;
1202
1203
GRANT UPDATE(f1) ON t1 TO 'mysqltest_1'@'localhost';
1203
1204
GRANT SELECT ON `test`.* TO 'mysqltest_1'@'localhost';
1204
1205
GRANT ALL ON db27878.* TO 'mysqltest_1'@'localhost';
1206
1207
CREATE SQL SECURITY INVOKER VIEW db27878.v1 AS SELECT * FROM test.t1;
1208
1209
UPDATE v1 SET f2 = 4;
1209
1210
ERROR HY000: View 'db27878.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
1210
1211
SELECT * FROM test.t1;
1354
1355
Warning 1403 There is no such grant defined for user 'userbug33464' on host 'localhost' on routine 'fn2'
1355
1356
DROP PROCEDURE sp3;
1356
1357
DROP USER 'userbug33464'@'localhost';
1358
1359
DROP DATABASE dbbug33464;
1360
SET @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;