I am trying to create a data source to connect to a MySQL database. When I put all my information, I get this error:
Connection error for data source: phoenix3 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Failed to create connection to database server. Attempt to reconnect 3 times. Give up. The main reason was as follows: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Failed to create a connection to the database server. Attempt to reconnect 3 times. Refuse.
I can’t fix it. Any suggestions?
Check your settings in mySql for maximum connections.
http://forums.mysql.com/read.php?39,181940,226710#msg-226710
Maybe MySql is blocking your CF server for some reason, maybe there are too many login errors for your cf user? if so, try cleaning your hosts.
http://www.oscararevalo.com/index.cfm/2010/10/28/Getting-MySQLNonTransientConnectionException-errors-Then-Your-MySQL-Server-Might-Be-Angry-At-You
You probably just changed the password or changed the table settings.
, ColdFusion 9, PHP 5 Ruby 1.9.2. CF9 MySQL, . CF "wwwrun" ( CFMX ). PHP GRANT WordPress ( "wwwrun" )... . WordPress , CF- .
Doh!
"wwwrun" . , . , JDBC . IMO.
, ColdFusion exceptions.log, .
, , exceptions.log, :
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'my_db_name'
, , , mysql, , .
mysql .