Hi, 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? The only way I could get to that instance is by using mysql --socket=/tmp/app_mysql.sock -u root. Thank you.
