[mysql] message from server:Host ‘xxx.xxx.xxx.xxx’ is blocked because of many connection errors

Daehee Kim

·

Follow

May 23, 2023

--

Listen

Share

unblock with mysqladmin flush-hosts

select @@global.max_connect_errors; --  check max connection error count

select @@global.max_connections; -- check  max connection count 

flush hosts; -- flushing hosts 

set global max_connections=number;

set global max_connect_errors=number;