Adkins, Randy wrote: > > So I go to datasources, add a new datasource using Other as > people have mentioned using the following: > > JBDC URL: jdbc:mysql://localhost:3306/myDevDB
To what IP does localhost resolve? Do you have IPv6 installed and are you attempting to connect to an IPv6 address? Have you triewd 127.0.0.1 and the public IP of MySQL? > Driver Class: com.mysql.jdbc.Driver > Driver Name: [nothing entered here] > Username: root > Password: [rootlevelpassword] > > and when I click Submit Changes I get the following error: > > Connection verification failed for data source: myDevDB > java.sql.SQLException: Timed out trying to establish connection > The root cause was that: java.sql.SQLException: Timed out trying to > establish connection > > Now, I use NaviCat and I can connect locally using that GUI interface > for MySQL. How does it connect? Using a named pipe or through a TCP port? > So any idea why in the world CFMX 7 has this issue? Download Ethereal and log the login attempt of CF MX on the database. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
