Hi,
using mysql 4.0.22-standard-log. one instance on port 3307 one instance on port 3306 (each binary in its own independent directory) unix 'root' account submits following commands and connects to mysql on default 3306 port instead of awaited 3307 port : ~mysqld/bin/mysql --port=3307 -p ~mysqld/bin/mysqldump -u root -p demo -a --add-drop-table --add-locks --opt -P3307> /tmp/demotest.sql using '--port' or '-P' gives the same result. This was tested without any .my.cnf file. Then I made a test with a config file : ~mysqld/bin/mysql --defaults-extra-file=my3307.cnf [client] password = mypassword port = 3307 This file was read : no password prompt. But I accessed the instance on port 3306. ( unix 'mysqld' account accesses properly the 3307 instance with option specified in .my.cnf file) What am I missing ? Is that a known bug ? similar to bug#5792 ? Thanks for your help, Andrew ------------------------------------------------------------- NetCourrier, votre bureau virtuel sur Internet : Mail, Agenda, Clubs, Toolbar... Web/Wap : www.netcourrier.com Téléphone/Fax : 08 92 69 00 21 (0,34 TTC/min) Minitel: 3615 NETCOURRIER (0,16 TTC/min) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]