uHost 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.

기존 아래 값이 10으로 되어 있었다. 

mysql> show variables like 'max_connect_errors';
| Variable_name      | Value |
| max_connect_errors | 10000 |
1 row in set (0.00 sec)

mysql> SET GLOBAL max_connect_errors=10000;

아래 실행한다.
 /usr/local/mysql/bin/mysqladmin -u root -p flush-hosts

유용했던 자료를 기록해 두었습니다. 도움이 되시길~~~ Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you fun

받은 트랙백이 없고 , 댓글이 없습니다.