safe_mysqld &

[Kyle D. Harris]

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!

[Steven E. Protter]

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

[Kyle D. Harris]

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

[Martin P.J. Zinser]

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

[Kyle D. Harris]

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

Kyle

[Paul Cross_1]

Kyle, what do your logs say?

[Steven E. Protter · Accepted solution]

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

[Martin P.J. Zinser]

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

[Martin P.J. Zinser]

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

[Kyle D. Harris]

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