Hello,

I Try to connect in cold fusion an database MySQL.

schema : test
user : test
pswd : test1234

One table : agent

Impossible to connect. I have the following error message:

Connection verification failed for data source: test
[]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?


Installation version of MySQL : 5.0.27
ColdFusion version: MX 6.01
Windows 2000 Professional

Actually, I have read the Adobe and MySQL Internet site and follow
all procedure. I have also downloaded the last and previous versions
of ODBC driver. If I use ODBC, the system hangs when I push on "test"
button.

file downloaded:

mysql-5.0.15-win32.zip
mysql-5.0.27-win32.zip

I tried the 2 versions (without result)

mysql-connector-java-3.1.11.zip
mysql-connector-java-3.1.14.zip
mysql-connector-java-5.0.4.zip

for the jar file, I tried the file in the following directories:

ColdFusion\wwwroot\WEB-INF\lib
ColdFusion\runtime\jre\lib
ColdFusion\runtime\jre\lib\ext
Java\jre1.5.0_05\lib
Java\jre1.5.0_05\lib\ext

(without result)

MyODBC-3.51.10-2-win.exe
MyODBC-3.51.11-1-win.exe
mysql-connector-odbc-3.51.12-win32.zip

Each file make the system to hang

I have tested all files above without result ....

What to do?????

I'm loss....

Help Help Help .....

Andre