wrongly i set owner on all the files in my server to root :
chown -R root /
now i have some problem with mysql server due to permission.
How can i set mysql owner to the correct files?
(I can't reinstall mysql server cause i have important table in my db )
Best Answer
On my CentOS box, the own and group is
mysql
and the install is here. This will fix your mysql permissions.chown -R mysql:mysql /var/lib/mysql
However,
chown -R root /
is no doubt going to have caused you a few more problems than simply MySQL.