[Maria/MySQL] ost 'x.x.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

I can't connect MariaDB in particular server using JDBC driver. When I try to connect db, error message than says "ost 'x.x.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" occurs.




It is related with database configuration. (max_connect_errors)

If a particular host make too many connect errors that exceeds allowed max_connect_errors count, database server consider this connection as hacking or inavlid connection. So, the server prevent connections from that host.

[Solution]

1. Initialize count

#> mysqladmin -uroot -p flush-hosts

2. Change max connect errors count

- in running

#> mysql -uroot -p

SET GLOBAL max_connect_errors=[COUNT];

- modify configuration file

#> vi /etc/my.conf