Mysql log warnings

From Wiki
Jump to: navigation, search

http://www.percona.com/blog/2012/12/28/auditing-login-attempts-in-mysql/

Error log

If you only care about failed attempts to login then there is another different and less problematic approach. From 5.5 it’s possible to log access denied messages to the error log.

Enable log_warnings in /etc/my.cnf and restart mysql.

log_warnings = 2