PDA

View Full Version : db_mysql.php help please


almightyone
07-26-2002, 08:49 PM
Warning: Host 'blh.blah.COM' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/websites/site.com/vb/admin/db_mysql.php on line 38

i have tried looking at this and can not fix it could someone tll me what this is and what ie xactly need to do as in some editors the line 38 is a different place all in the size it is opened anyways there is only 4 people on my board and every other pge load this is the error i would greatly appriciate some help

NTLDR
07-26-2002, 08:57 PM
I would guess from the error message that you need to run:

mysqladmin flush-hosts

on the MySQL Server, at least thats my understanding of the error message.

almightyone
07-26-2002, 09:01 PM
ok this can be ran from phpmyadmin? i have phpmyadmin installed as im not allowed to have shell access to the hosts mysql

Sparkz
07-26-2002, 09:41 PM
Well, if you are able to connect with phpmyadmin at all, you could just type flush hosts; as a query.

almightyone
07-26-2002, 09:42 PM
pok well ti does it now and then and of course when it does it i cant connect anywy at all what exactly does the flush hosts do and what is the hosts that is causing this problem if i may ask :p

Sparkz
07-26-2002, 09:55 PM
If the database is on the same server as your website is, you could always try to change the DB-host to localhost instead of whatever you have there now. Might do the trick.

If you're on a shared server, it's very possible that some other user has made a boo-boo in a script that messed up.

MySQL blocks hosts that fail to connect time after time. flush hosts merely empties the list of blocked hosts, you could say.

almightyone
07-26-2002, 11:48 PM
well i would assume its a shared server as when i goto my phpadmin in my fodler i can see a list of other names but only access mine? anywyas thanx for the help will do a flush and maybe fix the prob and might try the localhost and see