List:General Discussion« Previous MessageNext Message »
From:michael Date:March 3 2009 1:27am
Subject:Re: Enumerate MySQL Servers?
View as plain text  
Someone said look at you ODBC DNS list, and I think you are asking for a
method to programmatically find MySql servers, without looking at a ODBC
list on your screen.

If I were you, I would start/temporarily with assuming the MySql are
listening on port 3306, and write the appropriate socket code to connect
to port 3306, starting with IP xxx.xxx.xxx.0, xxx.xxx.xxx.1, and so on
until xxx.xxx.xxx.255

If you get connection refused, MySql is probably not listening on 3306, on
that IP.

For example: When I telnet to 127.0.0.1 port 3306 I get

"A5.0.45-community-nt", and some garbage.

So I know there is a MySql server listening on port 3306 on my local host.

Now, someone in the MySql development team should be able to tell you what
the various connect strings that you may run into from various versions
and platforms. Once you get this logic running smooth, then you can open
it up to all ports, and have a rock solid way to find all MySql servers
running on your network. That is, until a new version comes out ;-)

Could be a good method to monitor your MySql servers, better than just a
ping.

My $0.02,
Mike.
Thread
Enumerate MySQL Servers?Menachem Bazian2 Mar
  • Re: Enumerate MySQL Servers?Claudio Nanni3 Mar
    • Re: Enumerate MySQL Servers?michael3 Mar
      • Re: Enumerate MySQL Servers?michael3 Mar
  • RE: Enumerate MySQL Servers?Martin Gainty3 Mar