MySQL Forums
Forum List  »  MySQL Administrator

MySQL Log Login Attempts with out General Loging
Posted by: Glenn Sams
Date: September 19, 2011 12:11PM


I am in need of some way to log the login attempts made by users without all the queries you get when ding the general log. Reason is it's a production server and the general query log slows things way down, and typically the amount of queries that go through make the log file grow outrageously fast (1GB a hour).

Now I know mysql shouldn't be open to the public, but we a lot of servers hosted in different data centers and there is a replication between them. Despite the fact all usernames are bound to set host names, I would still like to track the incoming failed login's some how.

Options: ReplyQuote

Written By
MySQL Log Login Attempts with out General Loging
September 19, 2011 12:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.