List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:August 11 2009 3:38pm
Subject:RE: Replication - connecting a slave to a master on the same host via a port or socket
View as plain text  
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.braithwaite@stripped] 
Sent: 11 August 2009 16:12
To: mysql@stripped
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=1

Thread
Replication - connecting a slave to a master on the same host via a port or socketAndrew Braithwaite11 Aug
  • RE: Replication - connecting a slave to a master on the same host via a port or socketAndrew Braithwaite11 Aug
    • RE: Replication - connecting a slave to a master on the same hostvia a port or socketGavin Towey11 Aug
      • Re: Replication - connecting a slave to a master on the same host via a port or socketJohan De Meersman12 Aug