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