JackTurky JackTurky - 7 months ago 45
SQL Question

How to restore mysql privileges after bad chown

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 )

Answer

On my CentOS box, the own and group is mysql and the install is here. This will fix your mysql permissions.

chown mysql:mysql -R /var/lib/mysql

However, chown -R root / is no doubt going to have caused you a few more problems than simply MySQL.