EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / CF9 not connecting to MySQL5

   Reply to Discussion | New Discussion next >> 
Posted By Discussion Topic: CF9 not connecting to MySQL5

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

rickaclark
10-01-2013 @ 8:21 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 82
Joined: Dec 2005

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:




Website Designed and Developed by Pablo Varando.