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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]