�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Ftests%2F'>tests</a>/</p><hr><h3>✏️ Editing: grant.res</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>delete from user where user=&#039;grant_user&#039; or user=&#039;grant_user2&#039;
delete from db where user=&#039;grant_user&#039;
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: &#039;&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
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(&#039;test&#039;)
Error in execute: Can&#039;t find any matching row in the user table
set password FOR grant_user=password(&#039;test&#039;)
Connecting grant_user
Error on connect: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; (Using password: NO)
set password FOR grant_user=&#039;&#039;
Connecting grant_user
select * from mysql.user where user = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
grant select on *.* to grant_user@localhost,grant_user@localhost
show grants for grant_user@localhost
GRANT SELECT ON *.* TO &#039;grant_user&#039;@&#039;localhost&#039;

Connecting grant_user
insert into mysql.user (host,user) values (&#039;error&#039;,&#039;grant_user&#039;)
Error in execute: insert command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;user&#039;
update mysql.user set host=&#039;error&#039; WHERE user=&#039;grant_user&#039;
Error in execute: update command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;user&#039;
create table grant_test.test (a int,b int)
Error in execute: create command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
grant select on *.* to grant_user2@localhost
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; (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 &#039;grant_user&#039; on host &#039;opt_host&#039;
revoke select on grant_test.* from grant_user@opt_host
Error in execute: There is no such grant defined for user &#039;grant_user&#039; on host &#039;opt_host&#039;
revoke select on *.* from grant_user
Error in execute: There is no such grant defined for user &#039;grant_user&#039; on host &#039;%&#039;
grant select on grant_test.not_exists to grant_user
Error in execute: Table &#039;grant_test.not_exists&#039; doesn&#039;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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
set password FOR &#039;&#039;@&#039;&#039;=&#039;&#039;
Error in execute: Can&#039;t find any matching row in the user table
set password FOR root@localhost = password(&#039;test&#039;)
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;mysql&#039;
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 &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
show grants for grant_user@localhost
GRANT UPDATE, CREATE ON *.* TO &#039;grant_user&#039;@&#039;localhost&#039;

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 &#039;c&#039; in &#039;test&#039;
revoke select(c) on grant_test.test from grant_user@localhost
Error in execute: There is no such grant defined for user &#039;grant_user&#039; on host &#039;localhost&#039; on table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
delete from user where user=&#039;grant_user&#039;
flush privileges
delete from user where user=&#039;grant_user&#039;
flush privileges
grant select on grant_test.* to grant_user@localhost
select * from mysql.user where user = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;mysql&#039;
insert into grant_test.test values (4,0)
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
update grant_test.test set a=1
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
delete from grant_test.test
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
create table grant_test.test2 (a int)
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
ALTER TABLE grant_test.test add c int
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
CREATE INDEX dummy ON grant_test.test (a)
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
drop table grant_test.test
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
grant ALL PRIVILEGES on grant_test.* to grant_user2@localhost
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
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 &#039;grant_user&#039; on host &#039;localhost&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
REVOKE GRANT OPTION on grant_test.* from grant_user@localhost
Connecting grant_user
Error on connect: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
grant ALL PRIVILEGES on grant_test.* to grant_user@localhost
Connecting grant_user
select * from mysql.user where user = &#039;grant_user&#039;
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;mysql&#039;
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 (&#039;error&#039;,&#039;grant_user&#039;,0)
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;mysql&#039;
revoke ALL PRIVILEGES on grant_test.* from grant_user@localhost
select * from mysql.user where user = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
show keys from test
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
show columns from test2
a	int(11)	binary			0	

show keys from test2
select * from test
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
update grant_test.test set b=3 where b=1
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
update grant_test.test set b=b+1
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
update grant_test.test,test2 SET test.a=test2.a
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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 &gt; 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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
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 &gt; 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 &gt; 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 &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
update grant_test.test set b=b+1
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
select * from test
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
update test,test2 SET test2.a=test.a
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
update test,test2 SET test.a=test2.a
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
create table grant_test.test3 (a int)
Error in execute: create command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test3&#039;
alter table grant_test.test2 add c int
Error in execute: alter command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
grant insert on test2 to grant_user@localhost
Error in execute: Table &#039;mysql.test2&#039; doesn&#039;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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;c&#039; in table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
select count(*) from test,test2
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
replace into test2 SELECT a from test
Error in execute: delete command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
update test,test2 SET test.a=2 where test2.a&gt;100
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
update test,test2 SET test.a=test2.a
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
replace into test2 SELECT a,a from test
Error in execute: delete command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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&gt;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&gt;100
update test,test2 SET test2.a=test2.a where test2.a&gt;100
Error in execute: UPDATE command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
update test,test2 SET test2.c=test2.a where test2.a&gt;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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
grant select on grant_test.test2 to grant_user@localhost with grant option
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
rename table grant_test.test2 to grant_test.test3
Error in execute: insert command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test3&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test3&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test3&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test2&#039;
drop table if exists grant_test.test2,grant_test.test3
create database grant_test
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
drop database grant_test
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
delete from grant_test.test where A=2
Error in execute: delete command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
update test set b=5 where b&gt;0
Error in execute: update command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
update test,test2 SET test.b=5 where b&gt;0
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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 &#039;grant_user&#039; on host &#039;localhost&#039; on table &#039;test&#039;
delete from grant_test.test where a=2
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
update test set b=5 where b&gt;0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
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&gt;0
update test set a=11 where b&gt;5
Error in execute: UPDATE command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
update test,test2 SET test.b=5 where b&gt;0
update test,test2 SET test.a=11 where b&gt;0
Error in execute: UPDATE command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
update test,test2 SET test.b=test2.a where b&gt;0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
update test,test2 SET test.b=11 where test2.a&gt;0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test2&#039;
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 &#039;grant_user&#039; on host &#039;localhost&#039; on table &#039;test&#039;
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 &gt; 5
2

insert into test (b) values (5)
insert into test (b) values (a)
update test set b=3 where a &gt; 0
select * from test
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
select b from test
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
select a from test where b &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
insert into test (a) values (10)
Error in execute: INSERT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
insert into test (b) values (b)
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
insert into test (a,b) values (1,5)
Error in execute: INSERT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
insert into test (b) values (1),(b)
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
update test set b=3 where b &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
update test set b=4
Error in execute: update command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
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 &gt; 0
3	3

insert into test (b) values (9)
update test set b=6 where b &gt; 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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;a&#039; in table &#039;test&#039;
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 &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
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 &gt; 0
4

revoke select(b) on grant_test.test from grant_user@localhost
select count(a) from test where a+b &gt; 0
4

revoke select on grant_test.test from grant_user@localhost
Connecting grant_user
select count(a) from test where a+b &gt; 0
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
grant select(a) on grant_test.test to grant_user@localhost
select count(a) from test where a+b &gt; 0
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test&#039;
grant select on *.* to grant_user@localhost
Connecting grant_user
select count(a) from test where a+b &gt; 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 &gt; 0
4

select * from mysql.db where user = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;test&#039;
select * from mysql.user order by hostname
Error in execute: select command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for table &#039;user&#039;
select * from mysql.db where user = &#039;grant_user&#039;
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 = &#039;grant_user&#039;
select Host, Db, User, Table_name, Column_name, Column_priv from mysql.columns_priv where user = &#039;grant_user&#039;
delete from user where user=&#039;grant_user&#039;
delete from db where user=&#039;grant_user&#039;
flush privileges
show grants for grant_user@localhost
Error in execute: There is no such grant defined for user &#039;grant_user&#039; on host &#039;localhost&#039;
grant ALL PRIVILEGES on grant_test.test to grant_user@localhost identified by &#039;dummy&#039;,  grant_user@127.0.0.1 identified by &#039;dummy2&#039;
Connecting grant_user
grant SELECT on grant_test.* to grant_user@localhost identified by &#039;&#039;
Connecting grant_user
revoke ALL PRIVILEGES on grant_test.test from grant_user@localhost identified by &#039;&#039;, grant_user@127.0.0.1 identified by &#039;dummy2&#039;
revoke ALL PRIVILEGES on grant_test.* from grant_user@localhost identified by &#039;&#039;
show grants for grant_user@localhost
GRANT USAGE ON *.* TO &#039;grant_user&#039;@&#039;localhost&#039;

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 &#039;/tmp/mysql-grant.test&#039; 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: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test3&#039;
select a,b from grant_test.test3
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test3&#039;
select b from grant_test.test3
Error in execute: SELECT command denied to user: &#039;grant_user&#039;@&#039;localhost&#039; for column &#039;b&#039; in table &#039;test3&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
grant INSERT on grant_test.test3 to grant_user@localhost
Connecting grant_user
select * into outfile &#039;/tmp/mysql-grant.test&#039; from grant_test.test3
Error in execute: Access denied for user: &#039;grant_user&#039;@&#039;localhost&#039; (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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
grant LOCK TABLES on *.* to grant_user@localhost
show grants for grant_user@localhost
GRANT LOCK TABLES ON *.* TO &#039;grant_user&#039;@&#039;localhost&#039;
GRANT SELECT, INSERT ON `grant_test`.`test3` TO &#039;grant_user&#039;@&#039;localhost&#039;

select * from mysql.user where user=&#039;grant_user&#039;
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: &#039;grant_user&#039;@&#039;localhost&#039; to database &#039;grant_test&#039;
drop table grant_test.test3
show grants for grant_user@localhost
GRANT USAGE ON *.* TO &#039;grant_user&#039;@&#039;localhost&#039;

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 &#039;grant_user&#039;@&#039;localhost&#039; 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 &#039;grant_user&#039;@&#039;localhost&#039; 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 &#039;grant_user&#039;@&#039;localhost&#039; 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=&#039;grant_user&#039;
delete from db where user=&#039;grant_user&#039;
delete from tables_priv
delete from columns_priv
flush privileges
end of test
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Ftests'>🔙 Back</a></p>