Localhost resolves to the norm of 127.0.0.1. Using Navicat, I use Localhost to connect using TCP port 3306 Downloading Ethereal now.
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 2:28 PM To: CF-Talk Subject: Re: MySQL/CFMX7 is the death of me. 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:231485 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
