如何解决MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
在调试程序时发现数据库无法插入数据,提示报错MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
同一个ip在短时间内产生太多中断的数据库连接而导致阻塞;
1、 show variables like ‘%max_connect_errors%’;
提示:Empty set
2、设置最大值 set global max_connect_errors = 1000;
完美解决上述问题