Errors that may occur when CFMX is connected to MySQL4.1

The following articles mainly introduce the actual solutions that often encounter errors when CFMX connects to MySQL4.1. After upgrading the MySQL database to MySQL 4.1 today, an error occurs in the database that the program is connected, the admin data source cannot be connected. The error message is as follows:

 
 

  
  
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? 
 
 

I remember reading a blog and mentioning the solution, so "Hurry up"

First to mysql.com next to the latest JDBC driver, and then back to the compressed package in the "mysql-connector-java-3.1.6-bin.jar"
Put it in $ CFMX_HOME/runtime/servers/lib/(for CFMX Server Configuration) or $ JRUN_HOME/servers/lib/(for CFMX on JRun Configuration). for example, my machine is: C: \ blackstone \ runtime \ lib

Then restart CFMX.

Redefine the data source. In the "Driver" drop-down box, select "other". The following configuration is shown:

The data source is added successfully after submission.

An error occurred while updating the data source to mysql4.1 because the jdbc driver of cfmx is still old.

I believe that MM will update the built-in JDBC driver soon, but it is old in blackstone beta2.