Re: MySQL monitoring: too many bad connections from host

[Christopher P. Lindsey]

> I've setup monit 4.4 on a host to monitor a local MySQL database and a
> remote MySQL database by simply attempting to connect on port 3306 on each
> server. I left it running over night and when I came back in this morning
> I find that the MySQL database has blocked client accesses from the host
> due to "too many bad connections". I suspect this is because the test that
> monit is doing is simply opening the MySQL port and then closing it again
> - not actually executing any SQL statements and thus MySQL is seeing this
> as a bad connection attempt.

Yup, that's probably the problem.  You can start mysql with 

   -O max_connect_errors=999999999

to make the problem go away.  Alternatively, running the SQL command 

   FLUSH HOSTS

will reset the counter and re-enable connections once they're blocked.

Chris