mysql_multi permission denied
 

Hello,
I'm trying to run multiple mysql servers on a Mandrake 9.2 that came with a binary distrobution of mysql 4.0.15. Mandrake 9.2 set up the db file in /var/lib/mysql, but I could not find the my.cnf file so I read the mysql docs and have used the my-medium.cnf file as a starting point and copied it to /etc. then I used mysql_multi --example added that and commented out some of the original lines. I'm not sure how correctly I've done it but here is a part of the file. I know it gets read because it generated errors while I was modifying.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
#port = 3306
#socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs
# The MySQL server
#[mysqld]
#port = 3306
#socket = /var/lib/mysql/mysql.sock
#skip-locking
#key_buffer = 16M
#max_allowed_packet = 1M
#table_cache = 64
#sort_buffer_size = 512K
#net_buffer_length = 8K
#myisam_sort_buffer_size = 8M

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
password =<mypassword>

[mysqld2]
socket = /usr/mysql/mgb1/mysql.sock
port = 3308
pid-file = /usr/mysql/mgb1/my-mgb1.pid2
datadir = /usr/mysql/mgb1/mysql2
language = /usr/share/mysql/english
user = mgb

[mysqld3]
socket = /usr/mysql/mortiband/mortiband.sock3
port = 3309
pid-file = /usr/mysql/mortiband/my-mortiband.pid3
datadir = /usr/mysql/mortiband/mysql3
language = /usr/share/mysql/english
user = mortiband

Now when I use: mysql_multi start 2
I get this in the error log in /usr/mysql/mgb1/mysql2

031228 05:22:22 mysqld started
031228 5:22:22 Can't start server : Bind on unix socket: Permission denied
031228 5:22:22 Do you already have another mysqld server running on socket: /usr/mysql/mgb1/mysql.sock ?
031228 5:22:22 Aborting

031228 5:22:22 /usr/sbin/mysqld: Shutdown Complete

031228 05:22:22 mysqld ended

The original mysql socket is /var/lib/mysql/mysql.sock

Does mysql create the socket, or was I supposed to do something about that.

mysql owns /usr/mysql and everything in it.

Any help?

from what I red at mysql it sounded like option files was the way to go, but I'm thinking I should download a source copy and ./configure separate servers.

What do you think?

Any comments would be greatly appreciated. Thank you very much for any help you might be able to give.

newbie mgb