From: Wolfram Kraus (kraushagen-partner.de)
Date: Wed Jul 27 2005 - 05:01:17 CDT

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

amailpnetcourrier.com 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

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