2010年3月11日 星期四

出現blocked..many connection errors


進入ssh

打telnet 測此MySQL的主機

telnet 10.30.20.20 3306
Trying 10.30.20.20...
Connected to localhost.com.tw.
Escape character is '^]'.
pHost 'localhost s.com.tw' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.



打mysql -h 主機ip -u帳號 -p密碼
mysql -h 127.0.0.1 -uaccount -ppasswd

出現此訊息:
Host ’hostname’ is blocked because of many connection errors.
Unblock with ’mysqladmin flush-hosts’

解決方式為:
mysqladmin flush-hosts -u帳號 -p密碼
mysqladmin flush-hosts -uaccount -ppasswd

此錯誤訊息可將 max_connect_errors 設定加大,但需重開機

沒有留言: