1stop slave;
2drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3reset master;
4reset slave;
5drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6start slave;
7delete from mysql.user where user=_binary'rpl_ignore_grant';
8delete from mysql.db where user=_binary'rpl_ignore_grant';
9flush privileges;
10delete from mysql.user where user=_binary'rpl_ignore_grant';
11delete from mysql.db where user=_binary'rpl_ignore_grant';
12flush privileges;
13grant select on *.* to rpl_ignore_grant@localhost;
14grant drop on test.* to rpl_ignore_grant@localhost;
15show grants for rpl_ignore_grant@localhost;
16Grants for rpl_ignore_grant@localhost
17GRANT SELECT ON *.* TO 'rpl_ignore_grant'@'localhost'
18GRANT DROP ON `test`.* TO 'rpl_ignore_grant'@'localhost'
19show grants for rpl_ignore_grant@localhost;
20ERROR 42000: There is no such grant defined for user 'rpl_ignore_grant' on host 'localhost'
21select count(*) from mysql.user where user=_binary'rpl_ignore_grant';
22count(*)
230
24select count(*) from mysql.db where user=_binary'rpl_ignore_grant';
25count(*)
260
27grant select on *.* to rpl_ignore_grant@localhost;
28set password for rpl_ignore_grant@localhost=password("does it work?");
29select password<>_binary'' from mysql.user where user=_binary'rpl_ignore_grant';
30password<>_binary''
310
32delete from mysql.user where user=_binary'rpl_ignore_grant';
33delete from mysql.db where user=_binary'rpl_ignore_grant';
34flush privileges;
35delete from mysql.user where user=_binary'rpl_ignore_grant';
36delete from mysql.db where user=_binary'rpl_ignore_grant';
37flush privileges;
38