I messed up my mysql file ownerships

whatnoname · 06-06-2005, 09:46 PM

I've was having a little trouble installing mysql, but all seems ok now. (in as much as i can start/stop it, removed the default users & added paasword for mysql -u root). Except for the file ownership of some files in /var/lib/mysql. As you can see the group ownership is 507.

Code:

-rw-rw----  1 mysql mysql   79 Jun  7 00:45 host-bin.000007
-rw-rw----  1 mysql mysql 208K Jun  7 00:45 host-bin.000008
-rw-rw----  1 mysql mysql   79 Jun  7 00:45 host-bin.000009
-rw-rw----  1 mysql mysql  214 Jun  7 01:10 host-bin.000010
-rw-rw----  1 mysql mysql  239 Jun  7 01:22 host-bin.000011
-rw-rw----  1 mysql   507  198 Jun  7 01:21 host-bin.index
-rw-rw----  1 mysql root  5.2K Jun  7 01:50 host.aaa.co.uk.err
-rw-rw----  1 mysql   507  10M Jun  7 01:50 ibdata1
-rw-rw----  1 mysql   507 5.0M Jun  7 01:50 ib_logfile0
-rw-rw----  1 mysql   507 5.0M Apr 26 10:51 ib_logfile1
drwx--x--x  2 mysql root  4.0K Apr 26 10:51 mysql
drwxr-xr-x  2 mysql root  4.0K Apr 26 10:51 test

So what should the permissions be on these files? Would someone show me their output of ls -lh /var/lib/mysql please?

Similarly, the files in /var/lib/mysql/mysql are showing ownership as 507 too. Should these be the same uid for my current mysql group ? or set to root?

Thanks

juanbobo · 06-06-2005, 11:58 PM

They should all be owned by "mysql".

"chown mysql:mysql /var/lib/mysql/*"
"chown mysql:mysql /var/lib/mysql/mysql/*"

whatnoname · 06-07-2005, 08:33 AM

Thanks