Question

  Asked: Mar 17 2008   5:24 PM GMT
  Asked by: Ozzyit


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and Development.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Ozzyit  |   Mar 17 2008  7:10PM GMT

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 …. ??