At 12:15 +0100 7/28/02, Matt Darcy wrote: >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 ?
root starts safe_mysqld, which starts mysqld, which switches its user ID to mysqldba. safe_mysqld doesn't changed its ID, which is why it shows up as root. > >why is mysqld setting --datadir=/usr/locl when the script sets >datadir=/usr/local/mysql/var ? I suspect what you're seeing is simply an artifact of ps chopping off output lines. The full command probably is a little different. > >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