Our very own Aaron Lynch also has a nice blog entry on connecting to MySQL 5 with ColdFusion: Connecting to MYSQL 5.0 with ColdFusion MX7<http://ajlcom.instantspot.com/blog/index.cfm/2006/1/7/Connecting-to-MYSQL-50-with-ColdFusion-MX7>
On 9/18/07, Joe Kelly <[EMAIL PROTECTED]> wrote: > > Trying to play with Dave's Mach-II code (as well as some others), I > thought I'd post the solution to a problem I encountered as I'm sure > that many of you trying to set up a MySQL data source on CF7 will run > into this issue. > > Having been a while since installing MySQL on a windows box and trying > to set up a MySQL datasource through the CF7 administrator. I came up > with this error: > > Connection verification failed for data source: mysql_bad > java.sql.SQLException: Communication failure during handshake. Is > there a server running on localhost:3306? > The root cause was that: java.sql.SQLException: Communication failure > during handshake. Is there a server running on localhost:3306? > > Per the Adobe TechNote for CF MX, http://www.adobe.com/go/6ef0253 you > will need to follow these steps to set up your MySQL db for CF. > > To connect to a MySQL 4.1 or 5 database from ColdFusion MX: > > 1. Download a current, stable version of the MySQL Connector J JDBC > driver, available at: http://dev.mysql.com/downloads/ > > Note: Connector/J version 3.1.11 and higher cannot be used with > ColdFusion MX 7 because of MySQL bug 13469. Connector/J 3.1.10 should > be used instead for ColdFusion MX 7 until this MySQL bug is fixed. All > Connector/J version 3.0 releases and all version 3.2 releases work > with ColdFusion MX 7. > 2. Extract the mysql-connector-java-3.{n}-bin.jar file from the > downloaded archive file. > 3. Save the mysql-connector-java-3.{n}-bin.jar file in > thecf_root/WEB-INF/lib directory. > 4. Restart the ColdFusion MX server. > 5. Add a new data source to the ColdFusion MX Administrator, using > the driver option Other. > 6. Enter the JDBC URL: > jdbc:mysql://[host]:[port]/[database] > 7. Enter the Driver Class: > com.mysql.jdbc.Driver > 8. Complete username/password, and adjust other data source > settings, if needed. > 9. Submit the data source for verification. > > The exception being, to use the latest MySQL Connector. > I hope this helps anybody who runs into this problem! > Thanks, > Joe Kelly > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > -- ~Dave Shuck [EMAIL PROTECTED] http://daveshuck.instantspot.com
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
