Re: MySQL grant use?

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Ben Trussell
Date:  
To: Main PLUG discussion list
Subject: Re: MySQL grant use?
Come and live on the wild side Bryan!

On Fri, Jul 23, 2010 at 1:11 PM, Bryan O'Neal
<> wrote:
> 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
>

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