grant.res
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:31k
- delete from user where user='grant_user' or user='grant_user2'
- delete from db where user='grant_user'
- delete from tables_priv
- delete from columns_priv
- lock tables mysql.user write
- flush privileges
- unlock tables
- drop database grant_test
- create database grant_test
- Connecting grant_user
- Error on connect: Access denied for user: ''@'localhost' to database 'grant_test'
- grant select(user) on mysql.user to grant_user@localhost
- revoke select(user) on mysql.user from grant_user@localhost
- grant select on *.* to grant_user@localhost
- set password FOR grant_user2@localhost = password('test')
- Error in execute: Can't find any matching row in the user table
- set password FOR grant_user=password('test')
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' (Using password: NO)
- set password FOR grant_user=''
- Connecting grant_user
- select * from mysql.user where user = 'grant_user'
- localhost grant_user Y N N N N N N N N N N N N N N N N N N N N 0 0 0
- select * from mysql.db where user = 'grant_user'
- grant select on *.* to grant_user@localhost,grant_user@localhost
- show grants for grant_user@localhost
- GRANT SELECT ON *.* TO 'grant_user'@'localhost'
- Connecting grant_user
- insert into mysql.user (host,user) values ('error','grant_user')
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'user'
- update mysql.user set host='error' WHERE user='grant_user'
- Error in execute: update command denied to user: 'grant_user'@'localhost' for table 'user'
- create table grant_test.test (a int,b int)
- Error in execute: create command denied to user: 'grant_user'@'localhost' for table 'test'
- grant select on *.* to grant_user2@localhost
- Error in execute: Access denied for user: 'grant_user'@'localhost' (Using password: NO)
- revoke select on grant_test.test from grant_user@opt_host
- Error in execute: There is no such grant defined for user 'grant_user' on host 'opt_host'
- revoke select on grant_test.* from grant_user@opt_host
- Error in execute: There is no such grant defined for user 'grant_user' on host 'opt_host'
- revoke select on *.* from grant_user
- Error in execute: There is no such grant defined for user 'grant_user' on host '%'
- grant select on grant_test.not_exists to grant_user
- Error in execute: Table 'grant_test.not_exists' doesn't exist
- grant FILE on grant_test.test to grant_user
- Error in execute: Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used
- grant select on *.* to wrong___________user_name
- Error in execute: The host or user argument to GRANT is too long
- grant select on grant_test.* to wrong___________user_name
- Error in execute: The host or user argument to GRANT is too long
- Connecting grant_user
- grant select on grant_test.test to grant_user with grant option
- Error in execute: grant command denied to user: 'grant_user'@'localhost' for table 'test'
- set password FOR ''@''=''
- Error in execute: Can't find any matching row in the user table
- set password FOR root@localhost = password('test')
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'mysql'
- revoke select on *.* from grant_user@localhost
- grant create,update on *.* to grant_user@localhost
- Connecting grant_user
- flush privileges
- create table grant_test.test (a int,b int)
- update grant_test.test set b=b+1 where a > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- show grants for grant_user@localhost
- GRANT UPDATE, CREATE ON *.* TO 'grant_user'@'localhost'
- revoke update on *.* from grant_user@localhost
- Connecting grant_user
- grant select(c) on grant_test.test to grant_user@localhost
- Error in execute: Unknown column 'c' in 'test'
- revoke select(c) on grant_test.test from grant_user@localhost
- Error in execute: There is no such grant defined for user 'grant_user' on host 'localhost' on table 'test'
- grant select on grant_test.test to wrong___________user_name
- Error in execute: The host or user argument to GRANT is too long
- INSERT INTO grant_test.test values (2,0)
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'test'
- grant ALL PRIVILEGES on *.* to grant_user@localhost
- REVOKE INSERT on *.* from grant_user@localhost
- Connecting grant_user
- INSERT INTO grant_test.test values (1,0)
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'test'
- grant INSERT on *.* to grant_user@localhost
- Connecting grant_user
- INSERT INTO grant_test.test values (2,0)
- select count(*) from grant_test.test
- 1
- revoke SELECT on *.* from grant_user@localhost
- Connecting grant_user
- select count(*) from grant_test.test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- INSERT INTO grant_test.test values (3,0)
- grant SELECT on *.* to grant_user@localhost
- Connecting grant_user
- select count(*) from grant_test.test
- 2
- revoke ALL PRIVILEGES on *.* from grant_user@localhost
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- delete from user where user='grant_user'
- flush privileges
- delete from user where user='grant_user'
- flush privileges
- grant select on grant_test.* to grant_user@localhost
- select * from mysql.user where user = 'grant_user'
- localhost grant_user N N N N N N N N N N N N N N N N N N N N N 0 0 0
- select * from mysql.db where user = 'grant_user'
- localhost grant_test grant_user Y N N N N N N N N N N N
- Connecting grant_user
- select count(*) from grant_test.test
- 2
- select * from mysql.user where user = 'grant_user'
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'mysql'
- insert into grant_test.test values (4,0)
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- update grant_test.test set a=1
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- delete from grant_test.test
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- create table grant_test.test2 (a int)
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- ALTER TABLE grant_test.test add c int
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- CREATE INDEX dummy ON grant_test.test (a)
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- drop table grant_test.test
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant ALL PRIVILEGES on grant_test.* to grant_user2@localhost
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant ALL PRIVILEGES on grant_test.* to grant_user@localhost WITH GRANT OPTION
- Connecting grant_user
- insert into grant_test.test values (5,0)
- REVOKE ALL PRIVILEGES on * from grant_user@localhost
- Error in execute: There is no such grant defined for user 'grant_user' on host 'localhost'
- REVOKE ALL PRIVILEGES on *.* from grant_user@localhost
- REVOKE ALL PRIVILEGES on grant_test.* from grant_user@localhost
- REVOKE ALL PRIVILEGES on grant_test.* from grant_user@localhost
- Connecting grant_user
- insert into grant_test.test values (6,0)
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- REVOKE GRANT OPTION on grant_test.* from grant_user@localhost
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant ALL PRIVILEGES on grant_test.* to grant_user@localhost
- Connecting grant_user
- select * from mysql.user where user = 'grant_user'
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'mysql'
- insert into grant_test.test values (7,0)
- update grant_test.test set a=3 where a=2
- delete from grant_test.test where a=3
- create table grant_test.test2 (a int not null)
- alter table grant_test.test2 add b int
- create index dummy on grant_test.test2 (a)
- update test,test2 SET test.a=test2.a where test.a=test2.a
- drop table grant_test.test2
- show tables from grant_test
- test
- insert into mysql.user (host,user) values ('error','grant_user',0)
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'mysql'
- revoke ALL PRIVILEGES on grant_test.* from grant_user@localhost
- select * from mysql.user where user = 'grant_user'
- localhost grant_user N N N N N N N N N N N N N N N N N N N N N 0 0 0
- select * from mysql.db where user = 'grant_user'
- grant CREATE,UPDATE,DROP on grant_test.* to grant_user@localhost
- Connecting grant_user
- create table grant_test.test2 (a int not null)
- update test,test2 SET test.a=1 where 1
- update test,test2 SET test.a=test2.a where 1
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- grant SELECT on grant_test.* to grant_user@localhost
- Connecting grant_user
- update test,test2 SET test.a=test2.a where test2.a=test.a
- drop table grant_test.test2
- revoke ALL PRIVILEGES on grant_test.* from grant_user@localhost
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant create on grant_test.test2 to grant_user@localhost
- Connecting grant_user
- create table grant_test.test2 (a int not null)
- show tables
- test2
- show columns from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- show keys from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- show columns from test2
- a int(11) binary 0
- show keys from test2
- select * from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- grant insert on grant_test.test to grant_user@localhost
- show tables
- test
- test2
- insert into grant_test.test values (8,0)
- update grant_test.test set b=1
- Error in execute: update command denied to user: 'grant_user'@'localhost' for table 'test'
- grant update on grant_test.test to grant_user@localhost
- update grant_test.test set b=2
- update grant_test.test,test2 SET test.b=3
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant select on grant_test.test2 to grant_user@localhost
- update grant_test.test,test2 SET test.b=3
- revoke select on grant_test.test2 from grant_user@localhost
- delete from grant_test.test
- Error in execute: delete command denied to user: 'grant_user'@'localhost' for table 'test'
- grant delete on grant_test.test to grant_user@localhost
- delete from grant_test.test where a=1
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- update grant_test.test set b=3 where b=1
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- update grant_test.test set b=b+1
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- update grant_test.test,test2 SET test.a=test2.a
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant SELECT on *.* to grant_user@localhost
- Connecting grant_user
- update grant_test.test set b=b+1
- update grant_test.test set b=b+1 where a > 0
- update grant_test.test,test2 SET test.a=test2.a
- update grant_test.test,test2 SET test2.a=test.a
- Error in execute: UPDATE command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- revoke SELECT on *.* from grant_user@localhost
- grant SELECT on grant_test.* to grant_user@localhost
- Connecting grant_user
- update grant_test.test set b=b+1
- update grant_test.test set b=b+1 where a > 0
- grant UPDATE on *.* to grant_user@localhost
- Connecting grant_user
- update grant_test.test set b=b+1
- update grant_test.test set b=b+1 where a > 0
- revoke UPDATE on *.* from grant_user@localhost
- revoke SELECT on grant_test.* from grant_user@localhost
- Connecting grant_user
- update grant_test.test set b=b+1 where a > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- update grant_test.test set b=b+1
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- select * from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- grant select on grant_test.test to grant_user@localhost
- delete from grant_test.test where a=1
- update grant_test.test set b=2 where b=1
- update grant_test.test set b=b+1
- select count(*) from test
- 3
- update test,test2 SET test.b=4
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- update test,test2 SET test2.a=test.a
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- update test,test2 SET test.a=test2.a
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- create table grant_test.test3 (a int)
- Error in execute: create command denied to user: 'grant_user'@'localhost' for table 'test3'
- alter table grant_test.test2 add c int
- Error in execute: alter command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant alter on grant_test.test2 to grant_user@localhost
- alter table grant_test.test2 add c int
- create index dummy ON grant_test.test (a)
- Error in execute: index command denied to user: 'grant_user'@'localhost' for table 'test'
- grant index on grant_test.test2 to grant_user@localhost
- create index dummy ON grant_test.test2 (a)
- insert into test2 SELECT a,a from test
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant insert on test2 to grant_user@localhost
- Error in execute: Table 'mysql.test2' doesn't exist
- grant insert(a) on grant_test.test2 to grant_user@localhost
- insert into test2 SELECT a,a from test
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for column 'c' in table 'test2'
- grant insert(c) on grant_test.test2 to grant_user@localhost
- insert into test2 SELECT a,a from test
- select count(*) from test2,test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- select count(*) from test,test2
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- replace into test2 SELECT a from test
- Error in execute: delete command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant update on grant_test.test2 to grant_user@localhost
- update test,test2 SET test2.a=test.a
- update test,test2 SET test.b=test2.a where 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- update test,test2 SET test.a=2 where test2.a>100
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- update test,test2 SET test.a=test2.a
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- replace into test2 SELECT a,a from test
- Error in execute: delete command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant DELETE on grant_test.test2 to grant_user@localhost
- replace into test2 SELECT a,a from test
- insert into test (a) SELECT a from test2
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant SELECT on grant_test.test2 to grant_user@localhost
- update test,test2 SET test.b=test2.a where 0
- update test,test2 SET test.a=test2.a where test2.a>100
- revoke UPDATE on grant_test.test2 from grant_user@localhost
- grant UPDATE (c) on grant_test.test2 to grant_user@localhost
- update test,test2 SET test.b=test2.a where 0
- update test,test2 SET test.a=test2.a where test2.a>100
- update test,test2 SET test2.a=test2.a where test2.a>100
- Error in execute: UPDATE command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- update test,test2 SET test2.c=test2.a where test2.a>100
- revoke SELECT,UPDATE on grant_test.test2 from grant_user@localhost
- grant UPDATE on grant_test.test2 to grant_user@localhost
- drop table grant_test.test2
- Error in execute: drop command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant select on grant_test.test2 to grant_user@localhost with grant option
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- grant drop on grant_test.test2 to grant_user@localhost with grant option
- grant drop on grant_test.test2 to grant_user@localhost with grant option
- grant select on grant_test.test2 to grant_user@localhost with grant option
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test2'
- rename table grant_test.test2 to grant_test.test3
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'test3'
- grant CREATE,DROP on grant_test.test3 to grant_user@localhost
- rename table grant_test.test2 to grant_test.test3
- Error in execute: insert command denied to user: 'grant_user'@'localhost' for table 'test3'
- create table grant_test.test3 (a int)
- grant INSERT on grant_test.test3 to grant_user@localhost
- drop table grant_test.test3
- rename table grant_test.test2 to grant_test.test3
- rename table grant_test.test3 to grant_test.test2
- Error in execute: alter command denied to user: 'grant_user'@'localhost' for table 'test3'
- grant ALTER on grant_test.test3 to grant_user@localhost
- rename table grant_test.test3 to grant_test.test2
- revoke DROP on grant_test.test2 from grant_user@localhost
- rename table grant_test.test2 to grant_test.test3
- drop table if exists grant_test.test2,grant_test.test3
- Error in execute: drop command denied to user: 'grant_user'@'localhost' for table 'test2'
- drop table if exists grant_test.test2,grant_test.test3
- create database grant_test
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- drop database grant_test
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- flush tables
- Error in execute: Access denied. You need the RELOAD privilege for this operation
- flush privileges
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test2 root@localhost Update,Delete,Create,Grant,Index,Alter Insert
- localhost grant_test grant_user test root@localhost Select,Insert,Update,Delete
- localhost grant_test grant_user test3 root@localhost Insert,Create,Drop,Alter
- revoke ALL PRIVILEGES on grant_test.test from grant_user@localhost
- revoke ALL PRIVILEGES on grant_test.test2 from grant_user@localhost
- revoke ALL PRIVILEGES on grant_test.test3 from grant_user@localhost
- revoke GRANT OPTION on grant_test.test2 from grant_user@localhost
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- select count(a) from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- grant create,update on grant_test.test2 to grant_user@localhost
- create table grant_test.test2 (a int not null)
- delete from grant_test.test where a=2
- Error in execute: delete command denied to user: 'grant_user'@'localhost' for table 'test'
- delete from grant_test.test where A=2
- Error in execute: delete command denied to user: 'grant_user'@'localhost' for table 'test'
- update test set b=5 where b>0
- Error in execute: update command denied to user: 'grant_user'@'localhost' for table 'test'
- update test,test2 SET test.b=5 where b>0
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- grant update(b),delete on grant_test.test to grant_user@localhost
- revoke update(a) on grant_test.test from grant_user@localhost
- Error in execute: There is no such grant defined for user 'grant_user' on host 'localhost' on table 'test'
- delete from grant_test.test where a=2
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- update test set b=5 where b>0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- grant select(a),select(b) on grant_test.test to grant_user@localhost
- delete from grant_test.test where a=2
- delete from grant_test.test where A=2
- update test set b=5 where b>0
- update test set a=11 where b>5
- Error in execute: UPDATE command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- update test,test2 SET test.b=5 where b>0
- update test,test2 SET test.a=11 where b>0
- Error in execute: UPDATE command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- update test,test2 SET test.b=test2.a where b>0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- update test,test2 SET test.b=11 where test2.a>0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test2'
- select a,A from test
- 8 8
- 5 5
- 7 7
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test2 root@localhost Update,Create
- localhost grant_test grant_user test root@localhost Delete Select,Update
- revoke ALL PRIVILEGES on grant_test.test from grant_user@localhost
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test2 root@localhost Update,Create
- revoke GRANT OPTION on grant_test.test from grant_user@localhost
- Error in execute: There is no such grant defined for user 'grant_user' on host 'localhost' on table 'test'
- drop table grant_test.test2
- revoke create,update on grant_test.test2 from grant_user@localhost
- grant select(a) on grant_test.test to grant_user@localhost
- show full columns from test
- a int(11) binary YES NULL select
- b int(11) binary YES NULL
- grant insert (b), update (b) on grant_test.test to grant_user@localhost
- select count(a) from test
- 3
- select count(skr.a) from test as skr
- 3
- select count(a) from test where a > 5
- 2
- insert into test (b) values (5)
- insert into test (b) values (a)
- update test set b=3 where a > 0
- select * from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- select b from test
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- select a from test where b > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- insert into test (a) values (10)
- Error in execute: INSERT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- insert into test (b) values (b)
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- insert into test (a,b) values (1,5)
- Error in execute: INSERT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- insert into test (b) values (1),(b)
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- update test set b=3 where b > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test root@localhost Select,Insert,Update
- select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv
- localhost grant_test grant_user test b Insert,Update
- localhost grant_test grant_user test a Select
- revoke select(a), update (b) on grant_test.test from grant_user@localhost
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test root@localhost Insert
- select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv
- localhost grant_test grant_user test b Insert
- select count(a) from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- update test set b=4
- Error in execute: update command denied to user: 'grant_user'@'localhost' for table 'test'
- grant select(a,b), update (a,b) on grant_test.test to grant_user@localhost
- select count(a),count(b) from test where a+b > 0
- 3 3
- insert into test (b) values (9)
- update test set b=6 where b > 0
- flush privileges
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv
- localhost grant_test grant_user test root@localhost Select,Insert,Update
- select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv
- localhost grant_test grant_user test b Select,Insert,Update
- localhost grant_test grant_user test a Select,Update
- insert into test (a,b) values (12,12)
- Error in execute: INSERT command denied to user: 'grant_user'@'localhost' for column 'a' in table 'test'
- grant insert on grant_test.* to grant_user@localhost
- Connecting grant_user
- insert into test (a,b) values (13,13)
- revoke select(b) on grant_test.test from grant_user@localhost
- select count(a) from test where a+b > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- update test set b=5 where a=2
- grant select on grant_test.test to grant_user@localhost
- Connecting grant_user
- select count(a) from test where a+b > 0
- 4
- revoke select(b) on grant_test.test from grant_user@localhost
- select count(a) from test where a+b > 0
- 4
- revoke select on grant_test.test from grant_user@localhost
- Connecting grant_user
- select count(a) from test where a+b > 0
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- grant select(a) on grant_test.test to grant_user@localhost
- select count(a) from test where a+b > 0
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test'
- grant select on *.* to grant_user@localhost
- Connecting grant_user
- select count(a) from test where a+b > 0
- 4
- revoke select on *.* from grant_user@localhost
- grant select(b) on grant_test.test to grant_user@localhost
- Connecting grant_user
- select count(a) from test where a+b > 0
- 4
- select * from mysql.db where user = 'grant_user'
- localhost grant_test grant_user N Y N N N N N N N N N N
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv where user = 'grant_user'
- localhost grant_test grant_user test root@localhost Select,Insert,Update
- select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv where user = 'grant_user'
- localhost grant_test grant_user test b Select,Insert,Update
- localhost grant_test grant_user test a Select,Update
- revoke ALL PRIVILEGES on grant_test.test from grant_user@localhost
- select count(a) from test
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'test'
- select * from mysql.user order by hostname
- Error in execute: select command denied to user: 'grant_user'@'localhost' for table 'user'
- select * from mysql.db where user = 'grant_user'
- localhost grant_test grant_user N Y N N N N N N N N N N
- select Host, Db, User, Table_name, Grantor, Table_priv, Column_priv from mysql.tables_priv where user = 'grant_user'
- select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv where user = 'grant_user'
- delete from user where user='grant_user'
- delete from db where user='grant_user'
- flush privileges
- show grants for grant_user@localhost
- Error in execute: There is no such grant defined for user 'grant_user' on host 'localhost'
- grant ALL PRIVILEGES on grant_test.test to grant_user@localhost identified by 'dummy', grant_user@127.0.0.1 identified by 'dummy2'
- Connecting grant_user
- grant SELECT on grant_test.* to grant_user@localhost identified by ''
- Connecting grant_user
- revoke ALL PRIVILEGES on grant_test.test from grant_user@localhost identified by '', grant_user@127.0.0.1 identified by 'dummy2'
- revoke ALL PRIVILEGES on grant_test.* from grant_user@localhost identified by ''
- show grants for grant_user@localhost
- GRANT USAGE ON *.* TO 'grant_user'@'localhost'
- create table grant_test.test3 (a int, b int)
- grant SELECT on grant_test.test3 to grant_user@localhost
- grant FILE on *.* to grant_user@localhost
- insert into grant_test.test3 values (1,1)
- Connecting grant_user
- select * into outfile '/tmp/mysql-grant.test' from grant_test.test3
- revoke SELECT on grant_test.test3 from grant_user@localhost
- grant SELECT(a) on grant_test.test3 to grant_user@localhost
- select a from grant_test.test3
- 1
- select * from grant_test.test3
- Error in execute: select command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test3'
- select a,b from grant_test.test3
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test3'
- select b from grant_test.test3
- Error in execute: SELECT command denied to user: 'grant_user'@'localhost' for column 'b' in table 'test3'
- revoke SELECT(a) on grant_test.test3 from grant_user@localhost
- revoke FILE on *.* from grant_user@localhost
- drop table grant_test.test3
- create table grant_test.test3 (a int)
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant INSERT on grant_test.test3 to grant_user@localhost
- Connecting grant_user
- select * into outfile '/tmp/mysql-grant.test' from grant_test.test3
- Error in execute: Access denied for user: 'grant_user'@'localhost' (Using password: NO)
- grant SELECT on grant_test.test3 to grant_user@localhost
- Connecting grant_user
- LOCK TABLES grant_test.test3 READ
- Error in execute: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- grant LOCK TABLES on *.* to grant_user@localhost
- show grants for grant_user@localhost
- GRANT LOCK TABLES ON *.* TO 'grant_user'@'localhost'
- GRANT SELECT, INSERT ON `grant_test`.`test3` TO 'grant_user'@'localhost'
- select * from mysql.user where user='grant_user'
- 127.0.0.1 grant_user *042a99b3d247ae587783f647f2d69496d390aa71eab3 N N N N N N N N N N N N N N N N N N N N N 0 0 0
- localhost grant_user N N N N N N N N N N N N N N N N N Y N N N 0 0 0
- Connecting grant_user
- LOCK TABLES grant_test.test3 READ
- UNLOCK TABLES
- revoke SELECT,INSERT,UPDATE,DELETE on grant_test.test3 from grant_user@localhost
- Connecting grant_user
- revoke LOCK TABLES on *.* from grant_user@localhost
- Connecting grant_user
- Error on connect: Access denied for user: 'grant_user'@'localhost' to database 'grant_test'
- drop table grant_test.test3
- show grants for grant_user@localhost
- GRANT USAGE ON *.* TO 'grant_user'@'localhost'
- grant all on *.* to grant_user@localhost WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 2 MAX_CONNECTIONS_PER_HOUR 3
- show grants for grant_user@localhost
- GRANT ALL PRIVILEGES ON *.* TO 'grant_user'@'localhost' WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 2 MAX_CONNECTIONS_PER_HOUR 3
- revoke LOCK TABLES on *.* from grant_user@localhost
- flush privileges
- show grants for grant_user@localhost
- GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'grant_user'@'localhost' WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 2 MAX_CONNECTIONS_PER_HOUR 3
- revoke ALL PRIVILEGES on *.* from grant_user@localhost
- show grants for grant_user@localhost
- GRANT USAGE ON *.* TO 'grant_user'@'localhost' WITH MAX_QUERIES_PER_HOUR 1 MAX_UPDATES_PER_HOUR 2 MAX_CONNECTIONS_PER_HOUR 3
- drop database grant_test
- delete from user where user='grant_user'
- delete from db where user='grant_user'
- delete from tables_priv
- delete from columns_priv
- flush privileges
- end of test