On the cfdeveloper server a user today reported he was unable to connect to his database getting the following error on his site.
coldfusion windows com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
This left me scratching my head for a while as I could find no problems, until I tried to connect directly to mysql from the web server to the database server and got the following message back.
ERROR 1129 (HY000): Host 'myserver' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'
I didn't realise this about MySQL, but it appears it will block a server if too many errors occur. Simply running 'mysqladmin flush-hosts' on the MySQL server resolves the problem.
I thought this worth posting as I couldn't find anything else n google.