add user=mysql to the [mysqld] section of /etc/my.cnf
Sean Strycker wrote:
> I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
> I'll cut right to the chase - I've followed the directions in the manual for the
> binary install on Linux. but every time I start up the mysql daemon and do a pstree
> -laup, it's running as root.
> This is on a development / play machine so it's not that big a deal, but my system
> admin says that I have to run it as user=mysql.
> I've tried changing the mysql.server script, the my.cnf file, etc. I cant figure it
> out - how to make it start up and run as user=mysql!?!
> Anywho - any help would be appreciated.