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