MySQL - Error message: "Host 'XXX.XXX.XXX.XXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
Problem:
Brekeke CCS application cannot connect to the MySQL database, and the following error message is shown in application logs(cim.log / crm.log).
Example of the error message:
2022-10-11 15:08:49,562 [main] ERROR (Tenant.java:531) - [] [$] java.sql.SQLException: null, message from server: "Host '172.16.0.12' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
Solution:
Increase the value of the server system variable “max_connect_errors“.
my.cnf file:
[mysqld] max_connect_errors=10000
To change the value at runtime:
SET GLOBAL max_connect_errors=10000;
For details and precise instructions, please refer to the MySQL official manuals.