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 - 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 >> > >> --------------------------------------------------- >> 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 > --------------------------------------------------- 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