1include/master-slave.inc
2[connection master]
3create database d1;
4use d1;
5create table t (s1 int) engine=innodb;
6set @@autocommit=0;
7start transaction;
8insert into t values (1);
9create user x@y;
10grant select on t to x@y;
11rollback;
12show grants for x@y;
13Grants for x@y
14GRANT USAGE ON *.* TO `x`@`y`
15GRANT SELECT ON `d1`.`t` TO `x`@`y`
16start transaction;
17insert into t values (2);
18revoke select on t from x@y;
19commit;
20select * from t;
21s1
221
232
24show grants for x@y;
25Grants for x@y
26GRANT USAGE ON *.* TO `x`@`y`
27drop user x@y;
28drop database d1;
29include/rpl_end.inc
30