4 messages in com.mysql.lists.win32Host 'xxx.xxx.xxx.xxx' is blocked
FromSent OnAttachments
James Frankman29 Jul 2004 10:12 
SGr...@unimin.com29 Jul 2004 10:19 
James Frankman29 Jul 2004 10:55 
SGr...@unimin.com29 Jul 2004 11:14 
Subject:Host 'xxx.xxx.xxx.xxx' is blocked
From:James Frankman (jfra@idfbins.com)
Date:07/29/2004 10:12:42 AM
List:com.mysql.lists.win32

We have MySQL 4.0 running on our IIS web server. Occasionally, IIS crashes and
after restarting the server, we get the error message:

'' Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver]Host
'xxx.xxx.xxx.xxx' is blocked because of many connection errors. Unblock with
'mysqladmin fulsh-hosts' "

Other connections to MySQL work, only connections from IIS to MySQL fail until
the MySQL service is restarted. I have not tried 'flush hosts' since at the time
I wasn't familiar with the command, and I was under the gun to get our Intranet
back up. Restarting MySQL was my quickest option

A couple questions:

1. Is 'mysqladmin flush-hosts' equivelant to the mysql command 'flush hosts'? 2. How can I avoid this problem in the future?