Centos user permissions problem: forced to 777 lots of files

[inado1]

Hi,

I use Plesk 11.5.30 with Centos 6.5

For instance, i have the log for mysql (mysqld.log) which is owned by mysql:mysql. the log can't be written if the permissions aren't 777
I also had to switch logs owned by apache:apache to 777.

All tmp folders have to be 777.

Is it possible to give the mysql:mysql and apache:apache permissions of root:root.

I have tried to repair permissions using

for p in $(rpm -qa); do rpm --setugids $p; done
for p in $(rpm -qa); do rpm --setperms $p; done

But then, it changes some tmp folders in 755 and i have to turn them in 777.

According to you, should i change my httpd.conf user to root:root rather than apache:apache? and the user of my.cnf (for mysql) from mysql to root?

In your httpd.conf do you have apache:apache as user?
In your my.cnf do you have mysql as user?

I am lost about users for apache and mysql.

Help would be appreciated.

Thanks.

 

[inado1]

Fyi, i have decided to add mysql (user) and apache to /etc/sudoers under root ALL=(ALL) ALL