From: Keith Murphy Date: October 5 2012 5:02am Subject: Re: user last activity and log in List-Archive: http://lists.mysql.com/mysql/228337 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8f3b9e9906ee1304cb48c6eb --e89a8f3b9e9906ee1304cb48c6eb Content-Type: text/plain; charset=ISO-8859-1 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 --e89a8f3b9e9906ee1304cb48c6eb--