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