Results 1 to 2 of 2

Thread: Unblock with 'mysqladmin flush-hosts'?

  1. #1

    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 '' 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!
    Last edited by webcoder; 3 January, 2011 at 17:35 PM.

  2. 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:
    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, 21:36 PM
  3. Replies: 13
    Last Post: 8 November, 2009, 02:45 AM
  4. Replies: 10
    Last Post: 20 September, 2009, 20:34 PM

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