MySQL Ownership Incorrect

[mbsmi]

A few moments ago I incorrectly ran a chown command and gave all directories and files on my server ownership to root as shown below:

Code: Select all

chown / root:root

Now none of my sites can connect to their mysql database, I would assume due to MySQL not belonging to the correct user. My question, what folder(s) do I need to reset back to the mysql user and group? Also, are there other services that I need to do this same thing we?

Thanks for your help
Michael

[tjebbeke]

What is your OS?

[mehargags]

Friend... you are screwed!
you cannot undo that because you don't know user and group ownership of each and every file and directory under "/"

You best bet is :
1. Restore from a Snapshot if your VPS has that
2. Create a New fresh Server, then restore data from a Vesta daily Backup set to it and verify it with files in your previous server.

[skurudo]

Also, are there other services that I need to do this same thing we?

Michael, you can try to restore dirs/files ownership manyally, but this is hell of work
Take mehargags adviсe ;-)