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:[email protected]] Sent: Tuesday, August 11, 2009 8:38 AM To: [email protected] 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:[email protected]] Sent: 11 August 2009 16:12 To: [email protected] 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/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected] 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/[email protected]
