1include/master-slave.inc 2[connection master] 3connection master; 4grant select on *.* to 'user_foo'@'%' identified by 'user_foopass'; 5revoke select on *.* from 'user_foo'@'%'; 6select select_priv from mysql.user where user='user_foo' /* master:must be N */; 7Select_priv 8N 9connection slave; 10grant select on *.* to 'user_foo'@'%' identified by 'user_foopass'; 11revoke select on *.* from 'user_foo'@'%'; 12select select_priv from mysql.user where user='user_foo' /* slave:must be N */; 13Select_priv 14N 15grant select on *.* to 'user_foo'@'%' identified by 'user_foopass'; 16select select_priv from mysql.user where user='user_foo' /* slave:must be Y */; 17Select_priv 18Y 19connection master; 20revoke select on *.* from 'user_foo'; 21select select_priv from mysql.user where user='user_foo' /* master:must be N */; 22Select_priv 23N 24connection slave; 25select select_priv from mysql.user where user='user_foo' /* slave:must get Y */; 26Select_priv 27Y 28connection slave; 29revoke select on *.* FROM 'user_foo'; 30connection master; 31delete from mysql.user where user="user_foo"; 32connection slave; 33delete from mysql.user where user="user_foo"; 34include/rpl_end.inc 35