Question

Is there a server running on localhost: 3306?

MySQL, java.sql.SQLException, ColdFusion

Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error:

Connection verification failed for data source: cudefault
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

The easy way to see if there is a service listening on that port is to telnet to the port.

From a command prompt run telnet localhost 3306. If you get back a flashing cursor then a service is listening, If you get an error message then no service is listening.

#######Added by kb3cgj##############

You can also use netstat -a from the command line to get a list of services.

# Heff says:

Microsoft has acquired Mark Russinovich's Sysinternals operation and is distributing his terriffic
software for free. If you go to:
http://technet.microsoft.com/en-us/sysinternals/
drill down to Networking Utilities and download TCPView, you will have a wonderful utility
which tells you all you want to know about which process is holding your port.
If you sort on the 'Local Address' column, you can find the port you want and see which
process is bound to it. If you right-click the entry, you can see the full path to the executable
through 'Process Properties' and even terminate it.

Check out the rest of Marks software suite (free!) for lots of really useful windows utilities.