I think I've managed to change it so "mysql" is the user now. All the files in /var/lib/mysql are still owned by "root" - should I chown them so they belong to "mysql"?
[admin admin]$ ps auxw | grep mysqld root 6936 0.0 0.1 1672 824 ? S 15:04 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ mysql 6959 0.0 0.3 11624 1616 ? S 15:04 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 6961 0.0 0.3 11624 1616 ? S 15:04 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 6962 0.0 0.3 11624 1616 ? S 15:04 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- admin 17975 0.0 0.0 1364 508 pts/0 S 20:23 0:00 grep mysqld [admin admin]$ ----- Original Message ----- From: "Kamara Eric R-M" <[EMAIL PROTECTED]> To: "2Hosts.com" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 1:15 AM Subject: Re: changing mysqld deamon ownership. > > Yeah...I don't think you need to make any changes.. > > On Fri, 30 May 2003, 2Hosts.com wrote: > > > Thanks Kamara, > > > > So does that mean I don't need to change anything? > > > > > > > > > [admin admin]$ ps auxw | grep mysqld > > > > root 11073 0.0 0.1 1672 824 pts/0 S 01:12 0:00 sh > > > > /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ > > > > > > > Presumably the "root" on line one shows it's running as root? this > > > > paragraph in the book is extremely sketchy. > > > > > > What this line shows is that the script(in this case /usr/bin/safe_mysqld) > > > that starts the mysql daemon is run by root but that the server is running > > > as the user mysql. > > > > > > =============================== > > > Kamara Eric Rukidi Mpuuga > > > Computer Frontiers International > > > Plot 32 Lumumba Avenue > > > P.O Box 12510,Kampala > > > Tel :256-41-340417/71 > > > Email:[EMAIL PROTECTED] > > > Web :http://www.cfi.co.ug > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]