> Hi guys, > > On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner > should not be root, and to change it. I can't seem to find out how to do > this - could anyone guide me in the right direction please? > > I searched the list archives to no avail. > Many thanks. :o) >
Sorry, forgot to include this : [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/ mysql 11096 0.0 0.2 11568 1432 pts/0 S 01:12 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 11098 0.0 0.2 11568 1432 pts/0 S 01:12 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 11099 0.0 0.2 11568 1432 pts/0 S 01:12 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- admin 12307 0.0 0.0 1364 508 pts/0 S 01:36 0:00 grep mysqld [admin admin]$ Presumably the "root" on line one shows it's running as root? this paragraph in the book is extremely sketchy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]