MySQL grant use?

der.hans PLUGd at LuftHans.com
Thu Jul 22 23:00:07 MST 2010


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


More information about the PLUG-discuss mailing list