> So reading through some messages today I thought I would take a look at: > 'ps -ef | grep mysql' Which I assume tells me who owns/started the Mysql > processes? And I know it is not a good for Mysql to run as root so I was > curious as to whether this is the expected output and if not what do I > need to do to fix it? > > > root 4023 1 0 Feb08 ? 00:00:00 /bin/sh > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf > mysql 4047 4023 0 Feb08 ? 00:00:01 /usr/libexec/mysqld > --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql > --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking > > Thanks, > JP >From my side, you don't have to worry. The kernel has started mysql (process-id 4023) with root, but offers then IMHO the forks (or how they are called) by the user mysql (process-id 4047) Whenever mysql has to start such a new fork, you will see user mysql... HTH Roger
