We help IT Professionals succeed at work.

Sniff mysql instances on the network

sexyrexy
sexyrexy asked
on
386 Views
Last Modified: 2008-03-03
I am writing a setup wizard for an application that requires a database... right now it supports MSSQL 2000/2005 and MySQL 4 and 5. One of the requirements of the wizard is that it detect any servers running on the network (provided they are on a standard port and open to connections of course).

I can do this with MSSQL by broadcasting a UDP packet on 1434 and all servers will respond with basic info like name and version, but I have no idea how to do something similar with MySQL. So... how is it done?
Comment
Watch Question

Top Expert 2006

Commented:
Hi,

If you are sniffing port 3306 you may be able to try to logon with a blank username and password - and record the error message, if mysql is in it then there is a mysql server on that connection

a C++ implementation of this is located at

http://www.securiteam.com/tools/6Y00L0U5PC.html

Author

Commented:
That is impractical for this situation. I need something that will just *broadcast* to the network and wait for replies, not send a logon attempt to every address on the network.
Top Expert 2006
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.