We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MySQL Ownership Incorrect
MySQL Ownership Incorrect
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:
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
Code: Select all
chown / root:root
Thanks for your help
Michael
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MySQL Ownership Incorrect
What is your OS?
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: MySQL Ownership Incorrect
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.
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.
Re: MySQL Ownership Incorrect
Michael, you can try to restore dirs/files ownership manyally, but this is hell of workmbsmi wrote: Also, are there other services that I need to do this same thing we?
Take mehargags adviсe ;-)