Other then query the MySQL grant table I am not sure of a good way to
reconcile recent changes. As for out of sync replication stop the
replication, apply a backup, start replicaiton.

Sorry I don't have better advice. I can try playing around with some
stuff this weekend and would love to know your solution if you find
one before then.

On Thu, Jul 22, 2010 at 11:00 PM, der.hans <PLUGd@lufthans.com> wrote:
> moin moin,
>
> is there a way see when a particular grant was last used in MySQL? I can
> probably troll logs, but I wonder if it's in the DB.
>
> Also, how should I sync grants from master to slave when they're out of
> sync?
>
> In our case, the slave is also getting local changes. I'm pushing to stop
> that, but haven't yet gotten it worked out. The local changes to the slave
> didn't drop the missing grants, but since we've had emergency repairs
> after local changes caused problems, it might be that the repairs did
> cause the differences.
>
> ciao,
>
> der.hans
> --
> #  http://www.LuftHans.com/Classes        http://www.TwoGeekTechs.com/
> #  Director of Engineering, FonWallet Transaction Solutions, Inc.
> #  "The reasons for my decision to quit were myriad, but central to the
> #  decision was the realization that there are two kinds of companies:
> #  Good ones ask you to think for them.
> #  The others tell you to think like them." -- Benjy Feen
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss