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...
From: Andrew Braithwaite [mailto:andrew.braithwaite@stripped]
Sent: 11 August 2009 16:12
Subject: Replication - connecting a slave to a master on the same host
via a port or socket
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,
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql