Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Oct 2005
    Posts
    38

    Default mysql connection error

    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. #2
    cPanel Partner NOC cPanel Partner NOC Badge AndyReed's Avatar
    Join Date
    May 2004
    Location
    Minneapolis, MN
    Posts
    2,223

    Default

    Quote Originally Posted by JohnodACD
    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?
    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/...cked-host.html
    Andy Reed
    RHCE and CCNA
    ServerTune.com

Similar Threads & Tags
Similar threads

  1. FTP Connection Error : Error loading directory...
    By tuncayeskikoy in forum New User Questions
    Replies: 16
    Last Post: 11-14-2011, 07:03 AM
  2. Exim error " closed connection in response to initial connection"
    By senthil0787 in forum E-mail Discussions
    Replies: 2
    Last Post: 08-16-2009, 01:56 PM
  3. PuTTY Fatal Error, Network error: Connection timed out
    By cwuser in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 06-30-2007, 05:27 PM
  4. Bind Error shutting down due to TCP receive error: connection reset
    By eliteds3 in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 08-01-2006, 10:43 AM
  5. MySQL connection
    By AndyP in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 01-05-2006, 05:00 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube