On Tue, 10 Feb 2004 09:37:59 -0500 live4bacon@xxxxxxxxxxxxx wrote: > 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 i don't think you need to do anything. mysql isn't running as root, the shell that launched it is running as root. the mysql daemon has done what it is supposed to do and change its uid to the mysql user. richard -- Richard Welty rwelty@xxxxxxxxxxxxxxx Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security