I'm running Redhat 9 and setting up an Apache/MySQL/PHP webserver. The documentation I have been reading on MySQL, suggests that I should run the mysqld process as a non-root user. When I use the process status ($ ps) command to view the myqld process it shows root at the owner of mysqld (below)
$ ps auxw |grep mysqld
root 1767 0.0 0.0 4200 112 ? S 10:01 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
mysql 1797 0.0 0.0 13924 200 ? S 10:01 0:00 /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
greg 4070 0.0 0.2 3544 628 pts/2 D 16:22 0:00 grep mysqld

How can I change the ownership of this process?

Thanks, MJD