Multiple MySql Servers

[ejpoirier]

Trying to install MySql 4.1 to our Linux server that already has
version 4 installed. I created a my.cnf file and set the following
params:

datadir = /usr/local/mysql-4.1/data/
port = 3304
socket = /var/run/mysql4.1/mysql4.1.sock
pid-file = /var/run/mysql4.1/mysql4.1.pid
log = /var/log/mysql4/mysql4.1.log
The current installation is running from a different port and the data
dir, socket, pid-file, and log are in different locations.

I then attempt to start MySQL like this:

../mysqld_safe --defaults_file=/path/to/my.cnf --user=mysql &

I get the following error:

/var/run/mysqld/mysqld.pid: Permission denied
rm: cannot unlink `/var/run/mysqld/mysqld.pid': Permission denied
Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
../mysqld_safe: /var/log/mysqld.log: Permission denied
Please remove it manually and start ./mysqld_safe again
mysqld daemon not started

It's as if it is ignoring the "--defaults_file" parameter and using the
same my.cnf file that the previous installation has. Anyone have any
ideas as to what I need to do to get this working?

[boonkit]

The option is "--defaults-file=", not "--defaults_file="

ej*******@gmail.com wrote:

Trying to install MySql 4.1 to our Linux server that already has
version 4 installed. I created a my.cnf file and set the following
params:

datadir = /usr/local/mysql-4.1/data/
port = 3304
socket = /var/run/mysql4.1/mysql4.1.sock
pid-file = /var/run/mysql4.1/mysql4.1.pid
log = /var/log/mysql4/mysql4.1.log
The current installation is running from a different port and the data
dir, socket, pid-file, and log are in different locations.

I then attempt to start MySQL like this:

./mysqld_safe --defaults_file=/path/to/my.cnf --user=mysql &

I get the following error:

/var/run/mysqld/mysqld.pid: Permission denied
rm: cannot unlink `/var/run/mysqld/mysqld.pid': Permission denied
Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
./mysqld_safe: /var/log/mysqld.log: Permission denied
Please remove it manually and start ./mysqld_safe again
mysqld daemon not started

It's as if it is ignoring the "--defaults_file" parameter and using the
same my.cnf file that the previous installation has. Anyone have any
ideas as to what I need to do to get this working?