[+] Wiki Tools

Wiki Relationships:

Admin Tools:

Upload file

Question:mysqladmin host blocked because of many connection errors

Question of the Week #2

Hi, i'm getting this message when i try to enter a website:

Warning: mysql_pconnect(): Host '67.19.xx.xxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in C:\Websites\ratedesi\include\connectdb.php on line 9 Host '67.19.xx.xxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

I have no clue what to do

Edit

Answer

If this is your site and your IP address, then there are very likely network connection issues to the server. If this is not your IP address then it is likely an out of control program, possibly malicious.

A search using the Spike Error Buddy service returns the following explanation

A.2.5 `Host 'HOST_NAME' is blocked'
-----------------------------------

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. After
`max_connect_errors' failed     requests, `mysqld' assumes that
something is wrong     (for example, that someone is trying to break
in), and blocks the     host from further connections until you execute
a     `mysqladmin flush-hosts' command or issue a     `FLUSH HOSTS'
statement. See     *Note server-system-variables::.

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. If you are having network problems, it does you no good
to increase the value of the `max_connect_errors'     variable.

http://developer.spikesource.com/errorbuddy/source/mysql-4.1.13/Docs/mysql.info.p18#3184

Most Recent

Most Active Categories

Possible causes of too many connections

Mjoseph 16:31, 11 October 2005 (PDT)

You can also check for an application not properly closing database connections. In one instance, we had Tomcat configured to use persistent connections. However, each request initiated a new connection due to our incorrect configuration.

You can use

 mysqladmin -u <user> -p<password> processlist

to see a list of current connections.

Improved behavior in MySQL 5.1

WombatNation 13:19, 05 April 2008 (PDT)

In MySQL 5.1, the connection error tracking behavior was changed so that a successful connection from a host resets the connection error counter back to zero for that host. This is a big improvement if you have a server with a really long uptime and you have clients connecting from hosts with intermittent connection issues. If you use the default setting with MySQL 5.0 and earlier, a client could be locked out even if errors rarely occur, simply because the error count reached 10 for that host over the long uptime for the server (or long period of time between running the flush hosts command).

The new behavior in MySQL 5.1 generally allows you to keep the `max_connect_errors' system variable low, thus hopefully achieving the original purpose of helping protect your database server from direct connections from hostile hosts.

On the other hand, the new behavior could be hiding intermittent connection error issues that you might want to know about and fix. But, nothing is stopping you from setting the count lower than 10.

Add New Article

Printable Page

Categories: Questions | Mysql