Skip to main content
X
Xtort
Inspiring
April 27, 2006
Question

MySQL DSN fails during handshake

  • April 27, 2006
  • 1 reply
  • 460 views
I am trying to connect to a MySQL database that is on another network. The port has been opened, and I am able to connect to it via telnet (to test). I cannot connect to it from my CFML MX7 admin when I am trying to create a DSN. I get the following error.

Connection verification failed for data source: MWEB
java.sql.SQLException: Communication failure during handshake. Is there a server running on xxx.xxxx.com:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on xxx.xxxx.com:3306?


Could this be because I have an out of date java handler? I know the remote database is accessible from the computer, because I can connect to it via mysql-admin from the same server. Any help would be greatly appreciated.
This topic has been closed for replies.

1 reply

X
XtortAuthor
Inspiring
April 27, 2006
Ok following the recommendations at this link MySQL db 4.1 or greater I am able to create the connection. Of course now it is saying that the username/password is a problem. I think this has to do with the database priveleges, or possibly how I am passing that information to the database.

Connection verification failed for data source: MySQL_MWEB
java.sql.SQLException: Access denied for user 'testuser'@'service.testnet.net' (using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user 'testuser'@'service.testnet.net' (using password: YES)

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices