When we run websites, our server and the websites and services that run on it are often vulnerable to external attacks, and our MySQL / MariaDB database server is no exception. If the Fail2Ban protection software is also available on your server, this short description will show you how to make your server more secure against attacks on your "Access denied for user root @ ip address (using password: YES / NO)" database server.

In this troubleshooter, we roll up a Fail2Ban block caused by an Apache error of type "AH01630: client denied by server configuration" caused by Matomo's web analytics system. Finally, we fix the problem by modifying the Fail2Ban filter in apache-auth.

As we run more and more websites on our server, the additional traffic also increases, leading to additional workload. This excess load is largely caused by the traffic generated by the robots. In this description, we will look at two ways to keep these useless robots away from our websites.