Is there a server running on localhost: 3306?

25 pts.
Tags:
ColdFusion
java.sql.SQLException
MySQL
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ozzyit
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following