Question
Coldfusion 6.1 Data Source Issue
I'm creating a Datasource in Coldfusion 6.1 and I've set it
up correctly, I'm sure, with the right name, password, default
database, etc. I've checked this against the settings I used to run
queries against the database, for instance, with other tools.
The system does not say the name or password is incorrect, which it does when I have them wrong, instead it says:
Connection verification failed for data source: fln
[]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?
This is odd, as it would suggest I've got the name and password for the DSN correct (as it says when I have them wrong) but it's suggesing no MySQL is running, even though it is as I can use a query tool with the same credentials?
Any ideas?
The system does not say the name or password is incorrect, which it does when I have them wrong, instead it says:
Connection verification failed for data source: fln
[]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?
This is odd, as it would suggest I've got the name and password for the DSN correct (as it says when I have them wrong) but it's suggesing no MySQL is running, even though it is as I can use a query tool with the same credentials?
Any ideas?