You can easily get around that behaviour by specifying 127.0.0.1, though :-)
On Tue, Aug 11, 2009 at 8:56 PM, Gavin Towey <gto...@ffn.com> wrote: > Andrew, > > Yes it's true, because when you specify localhost, you're using the local > socket file. The port only has meaning for TCP connections. > > Regards, > Gavin Towey > > -----Original Message----- > From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com] > Sent: Tuesday, August 11, 2009 8:38 AM > To: mysql@lists.mysql.com > Subject: RE: Replication - connecting a slave to a master on the same host > via a port or socket > > Ah. I have found that if you use 'localhost' to connect, you cannot > specify a port, it silently fails... > > You can connect using a hostname (even though it's the same server), > specifying a port... > > Andrew > > -----Original Message----- > From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com] > Sent: 11 August 2009 16:12 > To: mysql@lists.mysql.com > Subject: Replication - connecting a slave to a master on the same host > via a port or socket > > Hi, > > I have 2 mysql instances running on a server on different ports with > different datadirs and different .sock files. > > I can connect locally via the sock with the -S flag to mysql but I > cannot connect locally via port (-P flag). > > Does anyone know if there is a way to configure a mysql slave to use a > socket to connect to a master on localhost? > > If not; does anyone know a way to connect to another mysql instance on > the same linux server using a port? > > Thanks for your help, > > Andrew > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=andrew.braithwa...@lovefilm.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com > > > The information contained in this transmission may contain privileged and > confidential information. It is intended only for the use of the person(s) > named above. If you are not the intended recipient, you are hereby notified > that any review, dissemination, distribution or duplication of this > communication is strictly prohibited. If you are not the intended recipient, > please contact the sender by reply email and destroy all copies of the > original message. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.