List:General Discussion« Previous MessageNext Message »
From:Edson Noboru Yamada Date:March 20 2008 5:18pm
Subject:2 mysqld instances
View as plain text  
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.

Thread
2 mysqld instancesEdson Noboru Yamada20 Mar
  • Re: 2 mysqld instancesDan Nelson20 Mar
    • Re: 2 mysqld instancesEdson Noboru Yamada20 Mar
      • Re: 2 mysqld instancesPaul DuBois20 Mar