Update backup user permissions, remove the –single-transaction flag, or downgrade mysqldump.
How do I fix the "Host is Blocked" error when connecting to MySQL?
Validated on 20 Nov 2024 • Last edited on 18 Mar 2026
ERROR 1129 (HY000): Host 'host_name' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
A Host is Blocked error occurs when your server has received too many interrupted connection requests for your location. The default value of the max_connect_errors system variable is 100 connections in a short period of time.
If you are getting this error, ensure that your queries are not timing out and that your network connection is stable.
Related Topics
How do I fix the mysqldump "Couldn't execute FLUSH TABLES Access denied" error?
Why does MySQL shut down when importing data with the source command?
Use MySQL’s import command instead of source for handling large data imports.
How do I fix the "1227" error?
Remove or replace the DEFINER in the dump file.