Posts tagged sql
mysql host is blocked because of many connection errors
013 years ago
Error:
“host is blocked because of many connection errors unblock with ‘mysqladmin flush-hosts’”
to fix this increase ‘max_connect_errors’ which is 10 by default.
If you can afford to restart the MySQL server, enter below to your my.cnf and restart the MySQL service.
[mysqld]
max_connect_errors = 1000
If you can’t afford to restart the MySQL server, follow below steps.
In MySQL pormpt,
set global max_connect_errors = 1000 ;
Recent Comments