mysql Host ‘XXXXXX’ is blocked because of many connection errors

ERROR 1129 (00000): Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
这说明mysqld已经得到了大量(max_connect_errors)的主机’hostname’的在中途被中断了的连接请求。在 max_connect_errors次失败请求后,mysqld认定出错了(象来字一个黑客的攻击),并且阻止该站点进一步的连接,直到某人执行命令 mysqladmin flush-hosts。
缺省地,mysqld在10个连接错误后阻塞一台主机。你可以通过象这样启动服务器很容易地调整它: set global max_connect_errors=1000;


/usr/local/mysql/bin/mysqladmin flush-host -h -uroot

u0ERROR 1129 (00000): Host ” is blocked because of many connection errors. Unblock with ‘mysqladmin flush-hosts’

If you get the following error, it means that mysqld has received many connect requests from the host ‘host_name’ that have been interrupted in the middle:
dd@0 ‘host_name’ is blocked because of many connection errors.
0U:f&T3y!v x1@ m ~ z0Unblock with ‘mysqladmin flush-hosts’
h”]’\#_ N i!W.x n }0
7E h,o E”s0The number of interrupted connect requests allowed is determined by the value of the max_connect_errors system variable. After max_connect_errors failed requests, mysqld assumes that something is wrong (for example, that someone is trying to break in), and blocks the host from further connections until you execute a mysqladmin flush-hosts command or issue a FLUSH HOSTS statement. See Section 5.2.2, “Server System Variables”.

1R2t%@F”l @0By default, mysqld blocks a host after 10 connection errors. You can adjust the value by starting the server like this
> mysqld_safe –max_connect_errors=10000 &Host


Comments are closed.