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

Reply via email to