How to configure Fail2Ban to protect MySQL 8

Operating system: Ubuntu
OS version: 20.04.3


First of all, I tried to run this by selecting from Fail2ban Intrusion Detector Log Filters → MySqld-Auth and Filter Action Jails → MySqld-Auth with settings:
Action iptables-multiport
Port 3306,33060
Protocol TCP
Log file paths %(mysql_log)s

And it did not work, the fail2ban did not start because could not find a log.

In the tab Webmin → System → System Logs I created file /var/log/mysqld.log with settings:
Facilities auth
Priorities all

After changing logpath = %(mysql_log)s to logpath = /var/log/mysqld.log it does not work.

And more, In the file /etc/my.cnf inserted strings:
log_error = /var/log/mysqld.log
log-warnings = 2

And it still does not work.

On this, my searches on the forum and the Internet did not give me the resulting options.
Any help will be grateful.


This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.