Thank you very much for help.
--- On Tue, 3/15/11, Johan De Meersman <vegivamp@stripped> wrote:
> From: Johan De Meersman <vegivamp@stripped>
> Subject: Re: Certain replication
> To: database100@stripped
> Cc: replication@stripped
> Date: Tuesday, March 15, 2011, 12:24 PM
> ----- Original Message -----
> > From: "Database System" <database100@stripped>
> >
> > Does GRANT command should be replicated?
> > In my master my.ini file, I have binlog-do-db=mysql,
> But I granted a
> > user privilege, it was added on the master server, it
> was not
> > replicated. It is not in the binlog file. I think any
> change to the
> > mysql database should be replicated by my setting.
> What's wrong?
>
> Mmm... GRANT/REVOKE aren't, technically, statements against
> a database, they're statements against the authentication
> system. I suspect the binlog-do-db is why they don't
> replicate.
>
> Row-based replication may replicate them, as that
> replicates actual database changes instead of statements;
> but that option comes with it's own caveats.
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
