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
