MySQL connection error causes user blocked

1, every time after a period of online business will appear the following error:

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

2, need to use mysqladmin flush-hosts unlock the user

3, view error log 650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/3C/F0/wKioL1PDlhiw-A09AAP2NOgUEQM636.jpg "title = "2.png" alt= "Wkiol1pdlhiw-a09aap2nogueqm636.jpg"/>

4. Check the official documentation for Max_connect_errors's explanation as follows

When a user's consecutive error connection reaches the value of Max_connect_errors, and the user is locked out during no successful connection, it needs to be unlocked using flush hosts.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/3C/EF/wKioL1PDlFbiu86sAANMPPveMMU407.jpg "title=" 1.png " alt= "Wkiol1pdlfbiu86saanmppvemmu407.jpg"/>

5, modify the Max_connect_errors value size

Online Setup: Set global max_connect_errors=100000;

and modify the MY.CNF configuration file corresponding value, to ensure that the restart will also take effect.

This article is from the "composer" blog, make sure to keep this source http://zuoqujia.blog.51cto.com/9151800/1438042