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