One small correction. Init-connect doesn't require a restart of MySQL. I was thinking of init-file. So that's even better.
On Thursday, October 4, 2012, Keith Murphy wrote: > My friend Dave Holoboff wrote this up some time ago: > > > http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html > > You know you people sound like children. > > Really unprofessional. > > Go ahead --- call me names. i left middle school almost 30 years ago. It > won't bother me. > > Can we knock off the name calling and actually offer advice and possible > solutions? I thought that was what this list was for. > > For those of us out in the field doing things ... This might be your > ticket. It requires a restart of MySQL (which may or may not be acceptable) > bit it's a fairly clean solution. > > Minimal load, easy to query for your last connection time and how often > connections are made by a user. > > Again, requires a restart to enable (and disable) . Oh, and users with > "super" privileges won't be logged. > > Thanks, > > Keith > > -------------------------- > > Keith Murphy > Senior MySQL DBA > Principal Trainer > Paragon Consulting Services > http://www.paragon-cs.com > 850-637-3877 > > > > > > > > -- > > * > * > (c) 850-637-3877 > -- Keith Murphy Senior MySQL DBA Principal Trainer Paragon Consulting Services http://www.paragon-cs.com 850-637-3877
