S
S
s3ek2011-08-16 21:54:15
MySQL
s3ek, 2011-08-16 21:54:15

MySQL, many connection errors and flush-hosts?

There was a problem on the server with MySQL, some queries began to swear

Host 'myhost' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Naturally, the first thing I got on the server was to do
$mysqladmin flush-hosts -uroot -p
It did not help, it continues to write the same way. What are the options without restarting the MySQL service?
Mysql 5.1.39
FreeBSD 8

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
s3ek, 2011-08-17
@s3ek

All the guys, thank you all, the problem was solved, albeit in a slightly different way. The connection went to the wrong host corny.
Though with this error to understand and be picked in broad gulls. Interestingly, everything used to work OK, but as usual it surfaced at the most important moment;)

W
Wott, 2011-08-16
@Wott

Very strange - it should swear at all connections from this host.
And if there are problems, they must first be solved, otherwise the application will be blocked again and again. As an option - someone sorts out passwords for mysqld accessible from the outside - filter connections from the outside nafig.
And yet - there is a global variable that determines how many errors before blocking - you can raise it temporarily.

V
Vladislav, 2011-08-17
@click0

1. Install mytop
2. Read the logs carefully.
3. Is mysql running on a port? localhost? Or on sockets?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question