MySQL – Host is blocked because of many connection errors; unblock wi th ‘mysqladmin flush-hosts’

login into MySQL using command line –

mysql -u [username] -p
**** [MySQL password]

put the below command into MySQL window

SET GLOBAL max_connect_errors=10000;
set global max_connections = 200;

check veritable using command-

show variables like "max_connections";
show variables like "max_connect_errors";

Leave a comment

Your email address will not be published. Required fields are marked *