Linux CentOS MySQL
MySQL: ERROR 1129 (HY000) Host 'Crowder' is blocked because of many connection errors
May 13, 2016
0

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

About author

ZERIN

CEO & Founder (BdBooking.com - Online Hotel Booking System), CEO & Founder (TaskGum.com - Task Managment Software), CEO & Founder (InnKeyPro.com - Hotel ERP), Software Engineer & Solution Architect

How To Setup a Subdomain with SSL on Amazon Linux 2 AMI

I assume that you can login to Amazon Linux 2 AMI ...

Read more

MySQL “Order By Clause” Not Working with “SELECT DISTINCT and ORDER BY” after MySQL Update to 5.7

I have recently updated our MySQL server to MySQL ...

Read more

WHM:: PHP Mail is Not Working-Showing Its Disable

When your mail does not work, one example could be...

Read more

There are 0 comments

Leave a Reply

Your email address will not be published. Required fields are marked *