1include/master-slave.inc
2[connection master]
3connection master;
4set sql_mode="";
5delete from mysql.user where user=_binary'rpl_ignore_grant';
6delete from mysql.db where user=_binary'rpl_ignore_grant';
7flush privileges;
8connection slave;
9set sql_mode="";
10delete from mysql.user where user=_binary'rpl_ignore_grant';
11delete from mysql.db where user=_binary'rpl_ignore_grant';
12flush privileges;
13connection master;
14grant select on *.* to rpl_ignore_grant@localhost;
15grant drop on test.* to rpl_ignore_grant@localhost;
16show grants for rpl_ignore_grant@localhost;
17Grants for rpl_ignore_grant@localhost
18GRANT SELECT ON *.* TO `rpl_ignore_grant`@`localhost`
19GRANT DROP ON `test`.* TO `rpl_ignore_grant`@`localhost`
20connection slave;
21show grants for rpl_ignore_grant@localhost;
22ERROR 42000: There is no such grant defined for user 'rpl_ignore_grant' on host 'localhost'
23select count(*) from mysql.user where user=_binary'rpl_ignore_grant';
24count(*)
250
26select count(*) from mysql.db where user=_binary'rpl_ignore_grant';
27count(*)
280
29grant select on *.* to rpl_ignore_grant@localhost;
30connection master;
31set password for rpl_ignore_grant@localhost=password("does it work?");
32connection slave;
33select password<>_binary'' from mysql.user where user=_binary'rpl_ignore_grant';
34password<>_binary''
350
36connection master;
37delete from mysql.user where user=_binary'rpl_ignore_grant';
38delete from mysql.db where user=_binary'rpl_ignore_grant';
39flush privileges;
40connection slave;
41delete from mysql.user where user=_binary'rpl_ignore_grant';
42delete from mysql.db where user=_binary'rpl_ignore_grant';
43flush privileges;
44connection master;
45include/rpl_end.inc
46