Correction: If you get "Connection failed" no one is listening!
"Connection Refused" means someone is listening, you just don't know who. > 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. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=mich...@j3ksolutions.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
