Re: Replication - connecting a slave to a master on the same host via a port or socket

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.

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

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]

RE: Replication - connecting a slave to a master on the same host via a port or socket

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