Web Hosting Community Forums by ASPnix
Client Login Area
LiveZilla Live Chat Software
Results 1 to 9 of 9

Thread: #1129 unblock with 'mysqladmin flush-hosts

  1. #1
    Junior Member
    Join Date
    December 19, 2009
    Posts
    2

    Exclamation #1129 unblock with 'mysqladmin flush-hosts

    Hi
    I want to login to mysql.aspnix.com/mysql5, but I can't login and receive this message:
    Code:
    #1129 - Host 'cp.aspnix.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
    . I don't know how to flush-hosts. please assist me about it.

  2. #2
    Administrator
    Join Date
    October 11, 2008
    Location
    Aubrey, Tx
    Posts
    744

    Default

    Quote Originally Posted by moosavy View Post
    Hi
    I want to login to mysql.aspnix.com/mysql5, but I can't login and receive this message:
    Code:
    #1129 - Host 'cp.aspnix.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
    . I don't know how to flush-hosts. please assist me about it.
    We are working on addressing this issue. You may see MySQL5 go in and out as we adjust the performance settings.
    Christopher York
    ASPnix Operations Manager
    877-427-7649 ext 128
    chris@aspnix.com

  3. #3
    Administrator
    Join Date
    October 11, 2008
    Location
    Aubrey, Tx
    Posts
    744

    Default

    Updated the concurrent connections pool to a higher value number to address the increased connections on our MySQL 5 servers. This should resolve the "too many connections" notice.
    Christopher York
    ASPnix Operations Manager
    877-427-7649 ext 128
    chris@aspnix.com

  4. #4
    Junior Member
    Join Date
    December 19, 2009
    Posts
    2

    Default

    Thanks, my problem solved.

  5. #5
    Junior Member
    Join Date
    January 5, 2010
    Posts
    1

    Default

    Quote Originally Posted by moosavy View Post
    Hi
    I want to login to mysql.aspnix.com/mysql5, but I can't login and receive this message:
    Code:
    #1129 - Host 'cp.aspnix.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
    . I don't know how to flush-hosts. please assist me about it.
    please help me and try 2 unblck me or tell me how to get unblocked thank u

  6. #6
    Administrator
    Join Date
    October 11, 2008
    Location
    Aubrey, Tx
    Posts
    744

    Default

    Hosts flushed, we are investigating why this keeps happening to the PHPMyAdmin server, you now be able to connect.
    Christopher York
    ASPnix Operations Manager
    877-427-7649 ext 128
    chris@aspnix.com

  7. #7
    Junior Member
    Join Date
    April 1, 2010
    Posts
    1

    Default

    Hey, I've got a similar issue and this was the best thread I could find after doing a google search.

    I need to log in to PHPMyAdmin on my local university server. The address is: https://www.cs.cf.ac.uk/phpMyAdmin/

    However, I get the response:
    _______________________________________
    Error

    MySQL said:
    Host 'blazon.cs.cf.ac.uk' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
    __________________________________

    Can I do the flush host command without being able to access the website? And if so, how can I do it?

    Any help would be greatly appreciated
    Thanks

  8. #8
    Administrator
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,054

    Default

    Unfortunately you can't. You need to login to server via RDP or SSH and run the command as admin.
    Roma
    Friendly ASPnix Administrator


    http://aspnix.com
    roma@aspnix.com
    1-877-427-7649



    ASPnix on Facebook

  9. #9

    Default

    The execution of "mysqladmin flush-host" on mySQL Server should fix this issue. To fix the issue permanently increase the value of "max_connect_errors" in mySQL configuration file.


    Solution is described here in detail: http://dev.mysql.com/doc/refman/5.1/...cked-host.html

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •