Error 1129

From Navicat Wiki
Jump to: navigation, search

Apply OS : Windows, Mac, Linux, iOS

Apply Navicat Product : Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No. : All


If you get the following error, it means that mysqld has received many connect requests from the host 'host_name' that have been interrupted in the middle:


Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'


The number of interrupted connect requests allowed is determined by the value of the max_connect_errors system variable. By default, mysqld blocks a host after 10 connection errors. You can adjust the value by starting the server like this:


shell> mysqld_safe --max_connect_errors=10000 &


If you get this error message for a given host, you should first verify that there isn't anything wrong with TCP/IP connections from that host.