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: | |
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
[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