Hi team,
I connect the internal application to the external MYSQL database connection. The error message that displayed when trying to get the data as, "Host '192.168.2.1' is blocked because of several connection problems; unblock with'mysqladmin flush-hosts'."
Hello,
That error means MySQL has received many interrupted connection requests from the given host. And the number exceeds the value of the max_connect_errors system variable.
For example, the current max_connect_errors value is 10. So if after 10 failed connection requests without a single successful connection, MySQL automatically blocks the host from further connections as a security precaution.
The following Article maybe help you
Thanks
Hello Kavinesh,
MySQL can handle 151 connection. If you exceed more than 151 connections it will throw an error.
You can increase the number of connections permanently or temporarily.
You can visit the following article to understand how to increase the max connections:
https://ubiq.co/database-blog/how-to-increase-max-connections-in-mysql/
Hope this helps :)