Troubleshooting of connection failure of a network-based MySQL database

After receiving a call from the customer, the customer said that a software I made (downloaded data from the MySQL database of the public network host) prompts "unable to connect to the network database", but it is normal to copy the software from the Organization and use it. This situation has also been encountered before. The main problem is that the user IP address is blocked.

The information found on the network is as follows:

========================================================== ====================================

Host ''hostname'' is blocked because of your connection errors.

This means that mysqld has obtained a large number of connection requests (max_connect_errors) with the host ''hostname'' interrupted in the middle. After the max_connect_errors failed request, mysqld determined that an error occurred (this is considered an attack from a hacker), so it blocked the site from further connection until the command mysqladmin was executed.
Flush-hosts.

By default, mysqld blocks a host after 10 connection errors. You can adjust it using the following code:

Shell> safe_mysqld-O max_connect_errors = 10000

========================================================== ====================================

It's easier for me to handle it. Restart MySQL directly!

ZZ: http://blog.csdn.net/zhourongbiao/archive/2006/08/03/1014298.aspx