Hi,
I have copied the file ./support-files/mysql.server to
/etc/init.d/mysql_server.
I have edited the /etc/init.d/mysql_server to set the basedir to
/usr/local/mysql and the datadir to /usr/local/mysql/var
When I compiled mysql I set the --with-mysqld-user=mysqldba flag.
I run (as root) /etc/init.d/mysql_server start
I see
$ ps -ef | grep mysql
mysqldba 20884 20719 0 11:55:31 pts/1 0:00 -ksh
mysqldba 20880 20865 0 11:55:11 pts/1 0:00
/usr/local/mysql/libexec/mysqld -
-basedir=/usr/local/mysql --datadir=/usr/local
root 20865 1 0 11:55:11 pts/1 0:00 /bin/sh
/usr/local/mysql/bin/safe
_mysqld --datadir=/usr/local/mysql/var --pid-f
$
as you can see the the parent (safe_mysqld)
sets --datadir=/usr/local/mysql/var (correct)
however the children processe owned by mysqldba sets datadir=/usr/local/
???? (why not /usr/local/mysql/var )
My Questions are..
Why is the root processes of mysql not owned by mysqldba ? do I need to add
an su - mysqldba at the start of the mysql_server script ?
why is mysqld setting --datadir=/usr/locl when the script sets
datadir=/usr/local/mysql/var ?
Thanks,
Matt.
---------------------------------------------------------------------
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
