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