Topic: CF9 not connecting to MySQL5


rickaclark    -- 10-01-2013 @ 8:21 AM
  I have been using MSaccess for years and have finally decided to switch to mySQL and have noting bt a basturd of a time trying to figure out how to switch over. I have installed mySQL5 and CF9 developer edition on my test machine at home. try as I might, I cannot connect to mySQL database. I keep getting the following error:


Connection verification failed for data source: test

java.sql.SQLException: Timed out trying to establish connection

The root cause was that: java.sql.SQLException: Timed out trying to establish connection


Below are my settings in the CF admin:


CF Data Source Name: MYSQL_test

JDBC URL: jdbc:mysql://localhost:3306/test

Driver Class: com.mysql.jdbc.Driver

Username: rickclark

password: ************


Help me save what little hair I have left and connect to mySQL server.

Below is mySQL settings:




EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=31&Topic=15336