- 1、使用mysqladmin flush-hosts
mysqladmin flush-hosts
mysqladmin -u root -p flush-hosts
- 2、修改max_connection_errors
set global max_connect_errors = 1000;
show variables like '%max_connection_errors%';
service mysqld restart
mysqladmin flush-hosts
mysqladmin -u root -p flush-hosts
set global max_connect_errors = 1000;
show variables like '%max_connection_errors%';
service mysqld restart