Originally Posted by arun5002
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
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?
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.