What does it all mean?

[Roger Grosswiler]

> 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