Bug #55578 GRANT PRIVILEGES FOR ROOT USER are not reflecting in SLAVE
Submitted: 27 Jul 2010 8:18 Modified: 28 Jul 2010 4:27
Reporter: Anil Alpati Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.45 OS:Linux (Ubuntu 9.04)
Assigned to: CPU Architecture:Any

[27 Jul 2010 8:18] Anil Alpati
Description:
GRANT PRIVILEGES FOR ROOT USER are not reflecting in SLAVE MACHINE

LIKE GRANTING , reset password and all other privileges are not reflecting in SLAVE MACHINE

How to repeat:
Same as in Description
[27 Jul 2010 8:53] Sveta Smirnova
Thank you for the report.

Please send us your master and slave configuration files.
[27 Jul 2010 11:56] Anil Alpati
Files attached.
[27 Jul 2010 11:56] Anil Alpati
Attached the files

Attachment: configfiles.zip (application/zip, text), 4.92 KiB.

[27 Jul 2010 15:56] Sveta Smirnova
Thank you for the feedback.

You have binlog-do-db options in master configuration file. In this case GRANT statements will be replicated only if you issued USE dbname before running it where dbname is name of database indicated in binlog-do-db option.
[28 Jul 2010 4:27] Anil Alpati
Its already enabled binlog-do-db for 'mysql' database.

I didn;t understand the following comment from you -
Could you please explain  - case GRANT statements will be replicated only if you issued USE dbname