FreePgs.com Forum

FreePgs Related => Support Requests => Topic started by: mlundela on December 01, 2005, 09:50:36 PM

Title: mysqladmin flush-hosts
Post by: mlundela on December 01, 2005, 09:50:36 PM
I am new to php and mySQL, and I got the following message when i tried to open my php-files:

Warning: mysql_connect() [function.mysql-connect]: #HY000Host '64.193.110.130' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in /fpgs/fpgshttpd/mlundela/test.php on line 3
#HY000Host '64.193.110.130' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

They worked just fine yesterday, and I haven't changed a thing.
Title: Re: mysqladmin flush-hosts
Post by: webzone (archived) on December 01, 2005, 09:59:44 PM
Make sure that you are using "localhost" as a database host and not "freepgs.com" and that the credentials in your script (username and password) are properly written. That would be the first troubleshooting step.

If the problem persists, I guess you'll have to wait for an admin.

By the way, I've got no problem with MySQL on my account.
Title: Re: mysqladmin flush-hosts
Post by: mlundela on December 01, 2005, 10:06:52 PM
I changed it to localhost, and now it works just fine:) Thanx alot!
Title: Re: mysqladmin flush-hosts
Post by: admin on December 01, 2005, 10:17:19 PM
We will flush the hosts.  This occurs because there were too many invalid connection attempts from this IP address (the machine IP).

You should always use "localhost" when connecting to the local machine so a TCP/IP socket is not used when one is not needed.

Thank you,
FreePgs.com Admin
Title: Re: mysqladmin flush-hosts
Post by: mlundela on December 01, 2005, 11:32:13 PM
What causes an invalid connection attempt? My code was a simply copy-paste from a tizag-tutorial, so I suppose it didn't contain any bugs..
Title: Re: mysqladmin flush-hosts
Post by: webzone (archived) on December 01, 2005, 11:50:14 PM
An invalid connection occurs when there is a wrong username/password combination that is provided to the MySQL server.

The problem was seen before here on freepgs. It is usually caused by a wrong username/password combination. It may be caused by another user doing to many invalid connections, which triggers the invalid login attempts protection in MySQL.