Question
Database Missing after Restore from Snapshot
I needed to restore my droplet from a snapshot after a problem. But now my WordPress database seems to be inaccessible or missing. Doesn’t restore from snapshot restore all data and files?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
Log in as super user or use sudo
Open /etc/mysql/my.cnf using gedit
Find bind-address, and change its value to the database server host machine’s IP address. For me, it was localhost or 127.0.0.1
Save and close the file.
Come back to terminal and execute sudo service mysql start
And it worked for me.