mysqladmin flush-hosts

[mlundela]

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.

[webzone (archived)]

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.

[mlundela]

I changed it to localhost, and now it works just fine:) Thanx alot!

[admin]

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

[mlundela]

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..

[webzone (archived)]

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.