--source include/master-slave.inc set global binlog_format='row'; set binlog_format='row'; create table test(f1 int); CREATE USER 'adminuser'@'1%.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'adminuser'@'1%.0.0.1' WITH GRANT OPTION; FLUSH PRIVILEGES; connect(admin,'127.0.0.1',adminuser,password,test,$MASTER_PORT); connection admin; CREATE USER 'testuser'@'localhost'; GRANT USAGE ON *.* TO 'testuser'@'localhost'; GRANT SELECT ON `test`.`test` TO 'testuser'@'localhost'; FLUSH PRIVILEGES; show binlog events; SELECT * FROM `mysql`.`tables_priv`; --sync_slave_with_master connection slave; SELECT * FROM `mysql`.`tables_priv`; connection master; SELECT * FROM `mysql`.`tables_priv`;