Shulou(Shulou.com)06/01 Report--

What if an error is reported in the mysql connection? I believe that many novice rookies can do nothing about this. Through the summary of this article, I hope you can find a solution. Here are the reasons and solutions for reporting errors in mysql connections.

The error is as follows:

ERROR 1129 (HY000): Host '10.0.14.251' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

The reasons are as follows:

Blocking caused by too many database connections interrupted by the same ip in a short period of time (exceeding the maximum of the mysql database max_connect_errors).

According to the prompt mysqladmin flush-hosts, it seems that the network connection needs to be refreshed.

Execution

Flush hosts

I found that the report was correct.

Follow the many connection errors in the prompt to view the mysql configuration max_connect_errors

Show global variables like 'max_connect_errors'

Just to be on the safe side, turn up this configuration

Set global max_connect_errors=1024

If you need to take effect permanently, remember to modify the mysql configuration file.

The above are the reasons and solutions for the error report of mysql connection, and you have to use it to know the specific essentials. If you want to read more related articles, you are welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.