Warning: mysql_connect() [function.mysql-connect] Host is blocked

Warning: mysql_connect() [function.mysql-connect]: Host ‘ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts

Solution :-

Check the MySQL connection and increase the max connection limit in my.cnf file.

mysql> show status like ‘Conn%’;
+—————+——-+
| Variable_name | Value |
+—————+——-+
| Connections | 404 |
+—————+——-+
1 row in set (0.00 sec)

mysql> show global status like ‘max%’;
+———————-+——-+
| Variable_name | Value |
+———————-+——-+
| Max_used_connections | 6 |
+———————-+——-+
1 row in set (0.00 sec)

mysql>

Restart the MySQL service, then check the logs.
==============>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s