Hi, I'm trying to start mysql with mysql IM, by following the steps as bellow:
1. change the use_mysqld_safe = 0 in the mysql.server 2.set /etc/my.cnf as: [client] #password = your_password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs [manager] default-mysqld-path = /usr/local/mysql/bin/mysqld socket=/tmp/manager.sock pid-file=/tmp/manager.pid monitoring-interval = 2 port = 1999 bind-address = 209.128.126.155 # The MySQL server [mysqld] mysqld-path=/usr/local/mysql5018_mmap_2/bin/mysqld socket=/tmp/mysql.sock port=3307 server_id=1 skip-stack-trace core-file skip-bdb log-bin log-error log=mylog log-slow-queries [mysqld2] port=3308 server_id=2 mysqld-path= /tests/jc_data/mysql- standard-5.0.15-solaris10-x86_64/bin/mysqld socket = /tmp/mysql.sock5 pid-file = /tmp/hostname.pid5 datadir= /tests/jc_data/mysql-standard-5.0.15-solaris10-x86_64/data log-bin log=/tmp/fordel.log 3. Then I start mysql by running mysql.server start 4. I noticed that a few problems: a. only the first mysqld(under /usr/local/mysql5018_mmap_2/bin/mysqld)started, the mysqld2 didn't start 5. If I run the client from /usr/local/mysql/bin/mysql mysql> show instances It complained wrong sysntax,that make me believe that commands for MySQL IM accepts are not available for some reason. Is there anything wrong with my above steps causing the problems? Thanks in advance for your information! Jenny