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 the databases are located in : /var/lib/mysql/mysql -rw-rw-r-- 1 root mysql 8778 2004-12-28 09:49 columns_priv.frm -rw-rw-r-- 1 root mysql 0 2004-12-28 09:49 columns_priv.MYD -rw-rw-r-- 1 root mysql 1024 2004-12-28 09:49 columns_priv.MYI -rw-rw-r-- 1 root mysql 9088 2004-12-28 09:49 db.frm -rw-rw-r-- 1 root mysql 306 2004-12-28 09:49 db.MYD -rw-rw-r-- 1 root mysql 3072 2004-12-28 09:49 db.MYI -rw-rw-r-- 1 root mysql 8641 2004-12-28 09:49 func.frm -rw-rw-r-- 1 root mysql 0 2004-12-28 09:49 func.MYD -rw-rw-r-- 1 root mysql 1024 2004-12-28 09:49 func.MYI -rw-rw-r-- 1 root mysql 9064 2004-12-28 09:49 host.frm -rw-rw-r-- 1 root mysql 0 2004-12-28 09:49 host.MYD -rw-rw-r-- 1 root mysql 1024 2004-12-28 09:49 host.MYI -rw-rw-r-- 1 root mysql 8877 2004-12-28 09:49 tables_priv.frm -rw-rw-r-- 1 root mysql 0 2004-12-28 09:49 tables_priv.MYD -rw-rw-r-- 1 root mysql 1024 2004-12-28 09:49 tables_priv.MYI -rw-rw-r-- 1 root mysql 9806 2004-12-28 09:49 user.frm -rw-rw-r-- 1 root mysql 372 2004-12-28 16:26 user.MYD -rw-rw-r-- 1 root mysql 2048 2004-12-28 16:29 user.MYI Do I need to change the owner of all these files or which ones need changing? Thank you for any help provided!!! -- Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]