[EMAIL PROTECTED] wrote:
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
Use the -h option for the host, otherwise mysql tries to connect via
socket:
~mysqld/bin/mysql --port=3307 -p -h 127.0.0.1
HTH,
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
