Re: MySQL grant use?

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Bryan O'Neal
Date:  
To: Main PLUG discussion list
Subject: Re: MySQL grant use?
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 <> 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
> <> 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 <> 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 - 
> >> To subscribe, unsubscribe, or to change your mail settings:
> >> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

> >>
> > ---------------------------------------------------
> > PLUG-discuss mailing list -
> > To subscribe, unsubscribe, or to change your mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss