I just set up mysql and found it running as root. I want to change it to run as mysql. I know I need an entry under [mysqld] in my.cnf. I also know the db directories and files need peermission changes but I'm confused on that. I use SuSE 9.1 and the datadir is:
/var/lib/mysql> ls -l total 13 drwxrwxr-x 2 root mysql 528 2004-12-28 09:49 mysql -rw-rw---- 1 mysql root 725 2004-12-29 08:36 mysqld.log -rw-r--r-- 1 root root 340 2004-12-28 15:45 mysqld.log-20041228.gz -rw-rw---- 1 mysql daemon 5 2004-12-29 08:36 mysqld.pid srwxrwxrwx 1 mysql daemon 0 2004-12-29 08:36 mysql.sock drwxrwxr-x 2 root mysql 48 2004-12-28 09:49 test
Russ:
chown -R mysql.mysql /var/lib/mysql
add
user=mysql in /etc/my.cnf
that should be enough, if for odd some reason it is not, read the error log, it will tell you what else needs to be fixed.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
