LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-28-2011, 04:45 AM   #1
arun5002
Member
 
Registered: Aug 2011
Location: Chennai,India
Distribution: Redhat,Centos,Ubuntu,Dedian
Posts: 549
Blog Entries: 5

Rep: Reputation: Disabled
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
 
Old 11-28-2011, 09:11 AM   #2
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,637

Rep: Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573Reputation: 2573
Quote:
Originally Posted by arun5002 View Post
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?

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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
check_nrpe -H remotehost - error Connection refused by host Storii Linux - Software 1 11-15-2011 02:56 AM
[SOLVED] check_log nrpe error: Connection refused by host sekreto Linux - Software 3 07-07-2011 01:53 AM
Can't SSH to some remove hosts: Connection Closed by Remote Host kvarkki Linux - Server 5 02-18-2010 06:44 AM
Dns Error: Connection to the remote host close mosharaf_linux Linux - Server 3 12-24-2008 05:34 AM
Error : ssh_exchange_identification: Connection closed by remote host sachinh Linux - Networking 2 04-03-2008 03:26 AM


All times are GMT -5. The time now is 11:35 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration