topic Re: safe_mysqld & in Operating System - Linux

safe_mysqld &

Kyle D. Harris — Mon, 05 Jan 2004 09:18:29 GMT

I tried running the "/usr/local/bin/safe_mysqld &" command to start the mysqld daemon and it said :

starting mysqld daemon with databases from /usr/local/var

mysqld daemon ended and then nothing... I have nooo clue what it means or what the problem could be. I think it's a simple fix but i'm not sure what. Thanks in advance!

Re: safe_mysqld &

Steven E. Protter — Mon, 05 Jan 2004 09:57:45 GMT

What user id are you using to start the databae?

Hopefully not root. Most databases are not designed to be started by root user.

You could try routing the output from the startup script to a file.

/usr/local/bin/safe_mysqld > /tmp/collector.txt

SEP

Re: safe_mysqld &

Kyle D. Harris — Mon, 05 Jan 2004 10:05:52 GMT

Yes Steven, I was username root. I believe i've done it before to another server serveral times as root and been successful.

Re: safe_mysqld &

Martin P.J. Zinser — Mon, 05 Jan 2004 11:16:49 GMT

Hello Kyle,

check out the mysql.server script in the
support-files directory. I have stuffed that into my init.d and it works without problems for to to start mysql automatically.

Greetings, Martin

Re: safe_mysqld &

Kyle D. Harris — Mon, 05 Jan 2004 12:59:11 GMT

Martin, where might that support-files directory be or what exactly is it called? Thanks.

Kyle

Re: safe_mysqld &

Paul Cross_1 — Mon, 05 Jan 2004 13:28:53 GMT

Kyle, what do your logs say?

Re: safe_mysqld &

Steven E. Protter — Mon, 05 Jan 2004 14:05:47 GMT

Well Kyle,

The standard instructions for Oracle, Software AG and other databases call for installation of binaries as a user other than root. That user owns the binaries and the shared memory areas that the database operates through.

I'm going to take a peek at the install guidelines, but would like to advise that running database software like this as root is a potential security hazard.

Not that this deals with your issue, but it might not be good practice.

If I find anything, I'll post back.

SEP

Re: safe_mysqld &

Martin P.J. Zinser — Mon, 05 Jan 2004 14:28:16 GMT

Hello,
the directory is named support-files in the source distribution. Loooking at my installed
binaries it can be found in

/usr/local/mysql/share/mysql/

Depending on where you have put your mysql installation the /usr/local part might vary for you.

I do agree with SEP on the general advise not to run the DB as root. I do have a book on MySQL that discusses all this quite well. I shall look the details up when I am at home.

Greetings, Martin

Re: safe_mysqld &

Martin P.J. Zinser — Mon, 05 Jan 2004 21:45:07 GMT

Hi again,

a book I liked about this stuff (also discusses security implications of running the server as root ;-) is

Paul DuBois
MySQL
Developers Library Sams
http://www.samspublishing.com/catalog/product.asp?product_id={FC784549-C0F6-44BC-8D69-393B557CDF40}

Generally speaking I do like the O'Reilly books very much, but for this particular topic found this book better.

Obviously all IMHO and YMMV ;-)

Greetings, Martin

Re: safe_mysqld &

Kyle D. Harris — Tue, 06 Jan 2004 08:10:28 GMT

Thanks Guys, i figured it out somehow... Don't ask how because i don't know.