I'm running Fedora 7, and i've been running mysql for a while. My server has 2 IP addresses, and would like to run two instances of mysql, one on each IP address. I am using the [mysqld_multi] group in my.cnf. I use [mysqld] and [mysqld2] for my two server settings. I'm using the canned init.d script to start mysqld. When i start mysql, the server starts, but it is only binding to the first IP. How do i get [mysqld2] running? also, when i run ps ax | grep my, i see mysqld_safe and mysqld running. Here is my my.cnf:
[mysqld_multi]
mysqld = /usr/libexec/mysqld
mysqladmin = /usr/bin/mysqladmin
user = mysql
[mysqld]
#mysqld=/usr/libexec/mysqld
#mysqladmin=/usr/bin/mysqladmin
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file = /usr/bin/mysql/hostname.pid
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_allowed_packet=32M
bind-address=192.168.0.60
#user=mysql
[mysqld2]
#mysqld=/usr/libexec/mysqld
#mysqladmin=/usr/bin/mysqladmin
datadir=/var/lib/mysql-dev
#socket=/var/lib/mysql/mysql-dev.sock
## Default to using old password format for compatibility with mysql 3.x
## clients (those using the mysqlclient10 compatibility package).
#old_passwords=1
#max_allowed_packet=32M
pid-file = /usr/bin/mysql/hostname-dev.pid
bind-address=192.168.0.62
#user-mysql
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid