JackTurky JackTurky - 2 years ago 175
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download