ColdFusion datasource doesn't connect properly

Question

I'm trying to create a datasource to connect to a MySQL database. When I put in all my info I get this error:

Connection verification failed for data source: phoenix3 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

I can't seem to fix it. Any suggestions?

Answer 1

Check your settings in mySql for max connections.

http://forums.mysql.com/read.php?39,181940,226710#msg-226710

Possibly MySql is blocking your CFserver for some reason, possibly too many login failures by your cf user? if so try flushing your hosts.

http://www.oscararevalo.com/index.cfm/2010/10/28/Getting-MySQLNonTransientConnectionException-errors-Then-Your-MySQL-Server-Might-Be-Angry-At-You