Edit File: rpl_binlog_grant.result
include/master-slave.inc [connection master] create database d1; use d1; create table t (s1 int) engine=innodb; set @@autocommit=0; start transaction; insert into t values (1); grant select on t to x@y; rollback; show grants for x@y; Grants for x@y GRANT USAGE ON *.* TO 'x'@'y' GRANT SELECT ON `d1`.`t` TO 'x'@'y' start transaction; insert into t values (2); revoke select on t from x@y; commit; select * from t; s1 1 2 show grants for x@y; Grants for x@y GRANT USAGE ON *.* TO 'x'@'y' drop user x@y; drop database d1; include/rpl_end.inc
Back to File Manager