database error host locked

[nato]

Warning: Host 'xxxx.xxxxx.com' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home282/n/a/nato98/public_html/vbulletin/admin/db_mysql.php3 on line 40

Warning: MySQL Connection Failed: Host 'xxxxxx.xxxxxxx.com' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home282/n/a/nato98/public_html/vbulletin/admin/db_mysql.php3 on line 40



There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

any ideas?

[George L]

mysql defaults to 10 max_connect_errors or failed requests from your host hostname before blocking the site from connecting to your mysql database until you execute the command

mysqladmin flush-hosts

you can try in your database server's /etc/my.cnf file add under

[mysqld] section add

set-variable = max_connect_errors=5000

and restart mysql

max_connect_errors
If there is more than this number of interrupted connections from a host this host will be blocked from further connections. You can unblock a host with the command FLUSH HOSTS.

as to the slight database problem, view the source of the error page and paste the mysql error message here

[nato]

Originally posted by eva2000
mysql defaults to 10 max_connect_errors or failed requests from your host hostname before blocking the site from connecting to your mysql database until you execute the command

mysqladmin flush-hosts

you can try in your database server's /etc/my.cnf file add under

[mysqld] section add
and restart mysql



as to the slight database problem, view the source of the error page and paste the mysql error message here

okay....in mysql newbie user terms, how do I do this?

here's the error message :

Database error in vBulletin Control Panel :

Link-ID == false, connect failed
mysql error: Host 'addr28.addr.com' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

mysql error number: 1129

Date: Tuesday 09th of April 2002 07:41:47 AM
Script: /vbulletin/admin/index.php3
Referer: