FIX: MySQL is blocked because of many connection errors;

Environment: CentOS 6.5,mysql 5.6.19

Problem:

Error when using Telnet to l0.0.1.120 3306 database

KHost ' l0.0.1.120 ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' Connection closed by foreign host.

Cause: The connection errors of the same IP exceeds the default maximum value.

Workaround 1:

Restart the MySQL service.

Workaround 2:

MySQL console from the command line

flush hosts;.

Workaround 3:

Modify the default number of max_connect_errors connections (MySQL 5.6 or above default is 100)

Show default number of connections: show variables like '%max_connect_errors% ';

Modify the number of connections:set Global max_connect_errors = 500; (Basically the same IP cannot exceed

Flush privileges;

Service MySQL Restart

This article is from "Happy Fish" blog, please make sure to keep this source http://01000.blog.51cto.com/2410614/1564528

FIX: MySQL is blocked because of many connection errors;