Forum Discussion
Problem Connecting MySQL: Host blocked
Hi experts,
I'm getting the error Host ‘IP’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts.
I have installed Connector/NET 8.0.21. I already increased the connection limit to 3000 but is not working and try with the command
The user has access to the server and I already executed mysqladmin flush-hosts command.
We don't have any gateway Installed as the refresh is manually.
Any idea?
Hi Anonymous
Do you connect it in desktop? and the refresh was manually triggerred in desktop?
Could you plz make sure you're using the latest MySQL connector?
Kindly refer to the solved case for more hints:
https://stackoverflow.com/questions/22285318/how-to-unblock-with-mysqladmin-flush-hosts
https://tableplus.com/blog/2019/08/host-is-blocked-because-of-many-connection-errors.html
2 Replies
Anonymous , were you able to connect to mysql, once? Check if ip whitelisting is needed.
Hi Anonymous
Do you connect it in desktop? and the refresh was manually triggerred in desktop?
Could you plz make sure you're using the latest MySQL connector?
Kindly refer to the solved case for more hints:
https://stackoverflow.com/questions/22285318/how-to-unblock-with-mysqladmin-flush-hosts
https://tableplus.com/blog/2019/08/host-is-blocked-because-of-many-connection-errors.html
