blocked because of many connection errors

----------------------------------------------- 서버 시작시 mysql 세팅 ----------------------------------------------

Host is blocked because of many connection errors; unblock with \'mysqladmin flush-hosts\'

1. flush-hosts

    mysqladmin -u root -p flush-hosts

2. sudo mysql -u root -p

    set global max_connections=999999;

    set global max_connect_errors=999999;

    show variables like '%max_connect%';

3. 접속자수 조회

mysql> show status like '%CONNECT%';

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| Aborted_connects         | 200   |

| Connections              | 300   |

| Max_used_connections     | 101   |   ==> 현재 연결된 접속수

| Ssl_client_connects      | 0     |

| Ssl_connect_renegotiates | 0     |

| Ssl_finished_connects    | 0     |

| Threads_connected        | 101   |   ==> 연결되었던 최대 접속수

+--------------------------+-------+