MySQL grant use?

[Bryan O'Neal]

I would not have that enabled on a production server, but you are correct
that if you do you can see almost everything

On Fri, Jul 23, 2010 at 12:03 PM, Ben Trussell <azlobo73 at gmail.com> wrote:

> With the general query log enabled in advance its easy to see when a
> and by whom a query was run, just be sure to put that log in the
> logrotate cycle because it can get big, fast..
>
> Ben
>
> On Fri, Jul 23, 2010 at 9:09 AM, Bryan O'Neal
> <Bryan.ONeal at theonealandassociates.com> wrote:
> > 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 at 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 at 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 at 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 at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100723/5cfa63d7/attachment.html>