The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community

Geekfinder
UFie Gear
Advertise on UF

Forum Rules
& FAQ


Username

Password


Create a New Account

 
 

Back to UserFriendly Strip Comments Index

Any MySQL gurus here? by andrej2002-09-29 18:48:13
  Check for --user by spoon 2002-09-29 22:59:10
Look at the mysqld rc.d script, check what user it's attemping to run mysql as. The line to look for is "--mysql". Most distribution try to run mysql as the user "mysql". If it is check the permissions on "/usr/local/mysql/var". It should be owned my mysql.mysql.

You can make mysqld run as another user by adding the "--user" to your rc.d script. For example this is mine.

start)
touch /var/log/mysqld.log
chown mysql.mysql /var/log/mysqld.log
/usr/local/mysql/bin/safe_mysqld \
--user=mysql \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/var \
--log=/var/log/mysqld.log \
--pid-file=/var/run/mysqld.pid &
ret=$?
if [ $ret -eq 0 ]; then
action "Starting MySQL: " /bin/true
else
action "Starting MySQL: " /bin/false
fi
[ $ret -eq 0 ] && touch /var/lock/subsys/mysqld
;;

Mine you, if you're running 4.x safe_mysqld becomes mysqld_safe.
[ Reply ]
    Thanks! by andrej2002-09-30 03:55:05

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)