The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql connection error

Discussion in 'General Discussion' started by JohnodACD, Jan 15, 2006.

  1. JohnodACD

    JohnodACD Active Member

    Joined:
    Oct 21, 2005
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    I am loosing hope i am posting here as a last reasourt. I have connecter a dedicated sql server via teh cpanel function and now i get this error every couple hours and i can not find where to look to see what is causeing it.

    Warning: mysql_connect(): Host '192.168.0.2' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

    Anyone knwo where i can find teh file that shows me the connection errors?
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    It is very possible that you have a network connection issues to the server. Or it is an application not properly closing database connections. One of our clients had a Php script using persistent connections. However, each request initiated a new connection due to our incorrect configuration.

    mysqladmin -u <user> -p<password> processlist
    That should show you a list of current connections.

    For more information, go to: http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html
     
Loading...

Share This Page