25 pts.
 Is there a server running on localhost: 3306?
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

Software/Hardware used:
ASKED: March 17, 2008  5:24 PM
UPDATED: March 19, 2008  5:06 PM

Answer Wiki:
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.
Last Wiki Answer Submitted:  March 19, 2008  5:06 pm  by  Pheffner   70 pts.
All Answer Wiki Contributors:  Pheffner   70 pts. , Kb3cgj   580 pts. , Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

I received the following after running the command:

C:>telnet localhost 3306

A
4.1.21-community-nt4╖☺BhgJ{OWI,ó!☻E^-`|o;vbigH

I guess that means there IS a service running on that port, eh? Now what? Still cant add the CF DSN …. huuummm …. ??

 25 pts.