Re: Broadcast to search available MySQL Server in Network?

[Manfred Süsens]

Yes, I tried to find the port 3306, but MySQL doesn't answer!

So, has MySQL a functionality to answer automatically? What is the port
number MySQL is listening? What kind of family MySQL use? Do MySQL use UDP
protocol?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Broadcast to search available MySQL Server in Network?

[Ugo Bellavance]

 -Message d'origine-
 De : Manfred Süsens [mailto:[EMAIL PROTECTED]
 Envoyé : Saturday, January 03, 2004 7:58 AM
 À : [EMAIL PROTECTED]
 Objet : Re: Broadcast to search available MySQL Server in Network?
 
 
 Yes, I tried to find the port 3306, but MySQL doesn't answer!

Maybe it is just not listening.  Do you have skip-networking in your my.cnf by any 
chance?  Is your server even started? How do you try to find the port?
 
 So, has MySQL a functionality to answer automatically? 

yes, of course, as long as the server is started and skip-neworking is not enabled.  
Using telnet you can check wether it is listening.  telnet hostname 3306 should give 
you something like: 
Connected to hostname.
Escape character is '^]'.
0
4.0.16-standard_l%q,%r4I,


What 
 is the port
 number MySQL is listening? 

3306/tcp
 What kind of family MySQL use? Do 
 MySQL use UDP
 protocol? 

no

hth

Ugo
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]
 
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Broadcast to search available MySQL Server in Network?

[robert_rowe]

Have you tried this code using:

 hostaddr.sin_port :=htons(3306);

I've never done this but the code looks like it is checking the appropriate port on 
all machines found. See what happens when you use the MySQL default port.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]