If you get the Host ‘host_name’ is blocked error message for a given host, you should first verify that there is nothing wrong with TCP/IP connections from that host. If you are having network problems, it does you no good to increase the value of the max_connect_errors variable.
First Check how many connect error your mysql allow as default. To do to that, first run mysql from console, once you are inside mysql, run the below command:
mysql> select @@global.max_connect_errors;
+—————————–+
| @@global.max_connect_errors |
+—————————–+
| 1 |
+—————————–+
1 row in set (0.00 sec)
Now Increase the value by running the below command:
mysql> SET GLOBAL max_connect_errors=10000;
Now, exit from mysql and Type the below command in Linux Console Mode:
# mysqladmin flush-hosts
There are 0 comments