Host 'host_name' is blocked because of many connection errors.[mysql]

上一篇 / 下一篇  2007-01-15 12:39:14 / 天气: Array / 个人分类:其他

[root@mo htdocs]# mysql -h172.16.xx.xx  -uroot -p木铎校园 BBS 社区$Sw9lJq JF]
Enter password:
d-QaV6L3j0ERROR 1129 (00000): Host '' is blocked because of many connection errors.  Unblock with 'mysqladmin flush-hosts'木铎校园 BBS 社区 Ug/?1B0Dl2Oy
木铎校园 BBS 社区(t8}4HN:gi4Y%q
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:
^Q*iw f/M7xr+_7w0
{a"\V[A~0Host 'host_name' is blocked because of many connection errors.木铎校园 BBS 社区OkRKmm d\&O/N;q!H
Unblock with 'mysqladmin flush-hosts'
2y L6Z'T*c&o z0
9R w:zbmMJ0The 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”.
^4n8Y8AkbLr Db0木铎校园 BBS 社区&kt'wLe}
By default, mysqld blocks a host after 10 connection errors. You can adjust the value by starting the server like this:
([6M't CY j&P eF0木铎校园 BBS 社区O'@uW%b6z2]
shell> mysqld_safe --max_connect_errors=10000 &
木铎校园 BBS 社区S!o |9R%])Jr0Wn

o ~Y+v y8t0
木铎校园 BBS 社区1S&F h-Jo.X^)C
如果想要忽略这种情况的发生:可以,木铎校园 BBS 社区#G!Z?k*fQ3Oqw
set [global] max_connect_errors=999999999 ;
.XU4P9U|!?S0
'?A:t+?,g0

TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

关于作者