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