Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 12-28-2003, 02:05 PM   #1
LQ Newbie
Registered: Sep 2003
Distribution: mandrake 9.0
Posts: 9

Rep: Reputation: 0
mysql_multi permission denied

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
#password = your_password
#port = 3306
#socket = /var/lib/mysql/mysql.sock

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

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

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

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
can't execute c++ binaries, "permission denied"... even though permission is 777 SerfurJ Programming 14 02-20-2009 05:50 AM
Permission Denied jamesvenning1 Linux - Newbie 4 06-05-2005 12:32 PM
Permission denied jagman026 Fedora 3 01-01-2005 04:45 PM
Permission Denied - Help!!! awolff01 Linux - Software 1 02-27-2003 03:23 PM
Permission denied? jbhoo Linux From Scratch 1 04-27-2002 10:12 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:35 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration