Multiple servers on a single host question

[siliconmike]

I have a single instance of MySQL package installed on FreeBSD. I run 2
servers. The second server is run with this command:

shell> mysqld_safe --defaults-extra-file=/root/my2.cnf &

some /root/my2.cnf file entries:
port = 3307
socket = /tmp/mysql2.sock

Both servers co-exist peacefully except:

shell> mysql --socket=/tmp/mysql2.sock [accesses second server
happily]

***BUT***

shell> mysql --port=3307 [accesses the first server and not the
second!!]

Does that mean that the first server's port 3306 is hard-coded into
MySQL ?

Is this a bug ?

Or am I missing something ?

What is the work-around ?

Mike

[Gordon Burditt]

>Both servers co-exist peacefully except:

shell> mysql --socket=/tmp/mysql2.sock [accesses second server
happily]

***BUT***

shell> mysql --port=3307 [accesses the first server and not the
second!!]

Does that mean that the first server's port 3306 is hard-coded into
MySQL ?
The default port is coded into MySQL. I don't see this as a problem.
Is this a bug ?

The port used is irrelevant if it's using the unix-domain socket.
It uses the unix-domain socket instead of the port if the host
is specified as or defaults to 'localhost'.

If you want to use the second server, specify BOTH the socket and
the port for the second server, which works regardless of
whether "--host localhost" or "--host my.server.com" is being
used.

Gordon L. Burditt

[siliconmike]

Gordon Burditt wrote:

Both servers co-exist peacefully except:

shell> mysql --socket=/tmp/mysql2.sock [accesses second server
happily]

***BUT***

shell> mysql --port=3307 [accesses the first server and not the
second!!]

Does that mean that the first server's port 3306 is hard-coded into
MySQL ?
The default port is coded into MySQL. I don't see this as a problem.

Is this a bug ?

The port used is irrelevant if it's using the unix-domain socket.
It uses the unix-domain socket instead of the port if the host
is specified as or defaults to 'localhost'.

I see. Thank you.
If you want to use the second server, specify BOTH the socket and
the port for the second server, which works regardless of
whether "--host localhost" or "--host my.server.com" is being
used.

Gordon L. Burditt