> chown -R mysql.mysql /var/lib/mysql
That's because there's user=root defined in safe_mysqld.
I just put there mysql and it works fine. I don't know how you, but I
don't like the .pid and .err file mixed with databases in the datadir.
MYSQL_UNIX_PORT=${MYSQL_UNIX_PORT:-/tmp/mysql.sock}
MYSQL_TCP_PORT=${MYSQL_TCP_PORT:-3306}
^user=mysql
# Use the mysqld-max binary by default if the user doesn't specify a
binary
if test -x $ledir/mysqld-max
then
MYSQLD=mysqld-max
else
MYSQLD=mysqld
fi
# these rely on $DATADIR by default, so we'll set them later on
^pid_file=/usr/local/mysql/run/`/bin/hostname`.pid
^err_log=/usr/local/mysql/log/`/bin/hostname`.err
SET_USER=0
My changed lines beginn with ^ sign.
Martin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php