Skip to main content
Inspiring
Aug 18, 2006 3:47 PM UTC
Answered

MySQL connection error

Hi

I have been told that i need to migrate from MS Access to MySQL.
I downloaded MySQL and have created a db etc....
Now when i need to create a datasource in the CF Administrator, I submit my DB details and get the following error...

Connection verification failed for data source: test
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3307?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3307?


Is there anyone that knows what is causing this error?

Thanks again
Pappy
This topic is closed to new replies. Start a new post to keep the conversation going.
Mr_PappyCorrect answer
Inspiring
Aug 21, 2006 8:06 AM UTC
Hi Defuse

Thanks for your assistance, but the issue was due to the fact that i was using mysql 5.

My issue has been resovled via a JDBC.

Regards
Pappy

5 replies

Participating Frequently
Aug 21, 2006 5:29 AM UTC
Your MySQL server is running on port 3307? The default is 3306, but that doesn't really mean anything.

Which version of MySQL are you running? I just answered a post a lot like this one.
Translate
Mr_PappyAuthorCorrect answer
Inspiring
Aug 21, 2006 8:06 AM UTC
Hi Defuse

Thanks for your assistance, but the issue was due to the fact that i was using mysql 5.

My issue has been resovled via a JDBC.

Regards
Pappy
Translate
Participating Frequently
Aug 18, 2006 5:53 PM UTC
Mr_PappyAuthor
Inspiring
Aug 21, 2006 8:08 AM UTC
Thank you.
Your assistance worked 100%!
Translate
Aug 18, 2006 5:42 PM UTC

Sounds like you need to install the MySQL driver?

Here's my guess:

1) CFMX 7 only supports MySQL DB ver3.x
2) Your MySQL version is higher than 3.x

By the way, I noticed in CF admin that you can specify a Driver type of 'Other'.

Therefore, my third guess is that you would need to specify the 'Other' option
when you create your datasource (after installing the mysql driver).

Good luck!
Translate