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 >