進入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 設定加大,但需重開機
沒有留言:
張貼留言