epoch1970;582798 Wrote: > > For reference, here is what I get on my machine wrt running mysql, and > the contents of the my.cnf file. As you see, the server fails when > launched as root, and works (sticks to much I have to kill it) when > invoked as user squeezeboxserver.
You mean, "mysql fails to launch as root when I invoke it incorrectly". The correct way to launch mysql as root is through the startup script. On Debian, this is /etc/init.d/mysql. ie, "/etc/init.d/mysql start". I don't know what Ubuntu has, but there is more to starting mysql than a single paramater. The debian startup script eventually calls 'mysqld_safe' which does, amongst other things, change the user from root to mysql (mysqld should NOT be run as root: it is a huge security risk, since it can write to files, it could easily be coerced to stomp on /etc/passwd for example). If you wish, you can use a system install of MySQL instead of the standalone version that SBS will invoke by itself. Especially useful if you already use MySQL for other things. But you should start it correctly, not by just running the daemon as root. > > Fatal error: Please read "Security" section of the manual to find out > how to run mysqld as root! -- snarlydwarf ------------------------------------------------------------------------ snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179 View this thread: http://forums.slimdevices.com/showthread.php?t=82338 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/unix
