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?
