When using the MySQL Driver provided in the list of driver options in the ColdFusion MX Administrator to connect to a MySQL 4.1 or MySQL 5database, the following error may occur:
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?
As of MySQL 4.1, the MySQL database authentication mechanism changed since earlier versions, and older MySQL JDBC drivers will not work unless either MySQL is configured to use the former authentication mechanism or a current version of the driver is used instead.
- 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.