amailpnetcourrier.com
Date: Tue Jul 26 2005 - 08:22:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]