Hi, all MySQL team

Thanks for your former help. Here is another question:
As MySQL support multiple instances, each instance will
run with different socket file and tcp/unix port number.
I want to know when using MySQL client programs like
mysqladmin to connect different instances, are both
socket file and port number parameter necessary(without any
Option file)?
For example:

we have 2 instances running on one machine

Instance "West" runs with /var/lib/mysql/west.sock and port: 3307
Instance "East" runs with /var/lib/mysql/east.sock and port: 3308


So if we want to connect to instance "East" using mysqladmin,
is following safety enough (not specify port number)?
 /usr/bin/mysqladmin -u root -p -S /var/lib/mysql/east.sock status

In addition, how about with C API like "mysql_real_connect()"?

Thanks for your help and
best wishes


Robert Li
Computer Associates
R&D Centre Beijing , China
Tel:    +86 10 6561 1136 ext 852 (O)
           +86 10 6731 1652 (H)
Fax:    +86 10 8529 8979
E-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to