i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? >===== Original Message From "R. Hannes Niedner" <[EMAIL PROTECTED]> ===== >On 11/10/02 9:14 PM, "daniel" <[EMAIL PROTECTED]> wrote: > >> running on localhost using the socket connection (as supposed to >> tcp/ip ). >> >> what are you saying that mysql can connect another way other than through >> mysql.sock ? > >If I am not mistaken the socket works only for a connection between server >and client running on the same host. It is more effective since it skips the >network stacks and you can see it as a kind of shortcut. But whenever you >connect from the outside (or use mysql -h localhost -P 3306 for the >localhost connection) the communication between client and server happens >via tcp/ip via port 3306 (standard port you may choose another if you see >fit or run several servers on the same host). This is very much like a >browser contacting a webserver via port 80 (again that is just the default). >I am sure other members on this excellent list will fill in the gaps or >correct me where I am in error. > >Best/h > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php