mysql 连接报错
ERROR 1129 (HY000): Host ‘192.168.1.123’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
一般max_connect_errors = 10,要调高错误连接的数量
解决办法
临时解决办法
use mysql;
show variables like 'max_connect_errors';
set global max_connect_errors = 1000;
flush hosts;
根本解决办法
修改
my.cnf
配置文件
vi /etc/my.cnf
max_connect_errors = 100