Host is blocked because of many connection error;unblock with mysqladmin-flush-hosts
 

Hi
i had configured mysql servr in centos distro 5.4 version .Frequently im getting these error out.

Host is blocked because of many connection error;unblock with mysqladmin-flush-hosts

i had placed max_connections=1000 in /etc/mysql/my.cnf still the issue persist after restartingof mysql serverproblem getting solved temporary .can some on help me out how can i permanently solve the issue

My my.cnf


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1

character-set-server=utf8
default-character-set=utf8
default-collation=utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-client = utf8

#[client]
#default-character-set=utf8

#added to increase limit of max packet size
max_allowed_packet=1G

max_connections=1000

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

How many users are connecting to the box? Where is it (internal corporate LAN, or serving up data on the Internet?) Did you run the mysqladmin-flush-hosts command, as the error told you to? Did you try to look this up on the MySQL knowledgebase?

http://dev.mysql.com/doc/refman/5.6/...cked-host.html
http://dev.mysql.com/doc/refman/5.6/...on-errors.html

Common problems are:

• Programs aren't behaving correctly, and leaving connections to the DB open, or are opening too many without releasing.
• Nagios SQL monitoring
• Bad passwords
• Network problems

Again, lots of things to check, and lots of places where the problem could be, and not enough detail provided here. Some research on your part is needed.