Results 1 to 2 of 2

Thread: Unblock with 'mysqladmin flush-hosts'?

  1. #1
    webcoder is offline Unknown Net Builder
    Join Date
    Dec 2010
    Posts
    7
    Thanks
    0
    Thanked 1 Time in 1 Post

    Unblock with 'mysqladmin flush-hosts'?

    Okay, I have a MYSQL database on one server and I am running it remotely on another. The remote server can accesses the database fine for a couple days (or a week) and then it stops working and gives me the following error:

    "Host '207.182.151.19' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

    My host has already flushed the hosts many times and has told me to make sure my queries were 'cleaner'. I don't want to have to keep making my host clear it because it puts all the other websites on their server at potential risk.

    What can be done to prevent this issues?
    Also, I have made sure all the mysql_connect's have been ended at each of the PHP documents.

    Help? Thanks!
    Coulton
    Last edited by webcoder; 3 January, 2011 at 16:35 PM.

  2. #2
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts
    Cheat.

    Create a cron job that runs `mysqladmin flush-hosts` once a day.

    If you don't have access to mysqladmin, do it in MySQL:
    Code:
    echo "flush hosts" | mysql  -hHOST -uUSER -pPASSWORD
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

Similar Threads

  1. How many hosts have you been on?
    By Sbfc_ in forum Web Hosting
    Replies: 21
    Last Post: 21 July, 2010, 11:59 AM
  2. New server or did my ISP unblock NB?
    By stickycarrots in forum General Chat
    Replies: 3
    Last Post: 8 November, 2009, 20:36 PM
  3. Replies: 13
    Last Post: 8 November, 2009, 01:45 AM
  4. Replies: 10
    Last Post: 20 September, 2009, 20:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

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