From: Dan Nelson
Date: March 20 2008 5:53pm
Subject: Re: 2 mysqld instances
List-Archive: http://lists.mysql.com/mysql/211889
Message-Id: <20080320175340.GB22636@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 20), Edson Noboru Yamada said:
> I have a single machine with 2 mysql instances running. One of them
> was started like this:
> 
> /home/y/libexec/mysqld --basedir=/home/mysql --datadir=/var/mysql/data --pid-file=/var/mysql/mysqld.pid --port=3306 --socket=/tmp/mysql.sock
> 
> and, the other one, like this:
> 
> /home/y/libexec/mysqld --defaults-extra-file=/var/app/data/my.cnf --basedir=/home/mysql --datadir=/var/app/data --user=mysql --pid-file=/var/run/mysqld.pid --port=3382 --socket=/tmp/app_mysql.sock
> 
> However, when I try to access the second instance using "mysql -u root
> -P3382", I land on the first instance. Why?

-P is only used when connecting to non-localhost addresses.  Try adding
"-h 127.0.0.1" to your commandline.

-- 
	Dan Nelson
	dnelson@stripped