Not the answer you need?
Register and ask your own question!

How to enable logging of failed accesses on MySQL 8.0

ultratronixultratronix EntrantCurrent User Role Novice
Hi everyone,
just installed my first MySQL 8.0 version. I need to log all failed access to mysql. I added "log-error-verbosity = 3" on my "mysqld.cnf" file of my Debian 10 distribution and restarted the server. Then I tried to emulate a failed login, but this event is not saved by any log file (in particular, the /var/log/mysql/error.log remains empty).

How can I enable failed log attempts on MySQL 8.0 so that I can use it in conjunction with fail2ban?

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hi ultratonix thanks for asking. Can I just check with you if you're using Percona Server for MySQL 8.0 or MySQL Community edition? I'm just wondering if the audit log plugin might help here? https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html
  • ultratronixultratronix Entrant Current User Role Novice
    Hi, thank you for your reply.
    I'm using MySQL Community edition. At the moment, no failed login attempts on any of the log files...
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.