By troy
Hi. I took a snapshot of one of my droplets, it’s the only snapshot I have. The snapshot includes a working MySQL database with login credentials. After creating a new droplet using the snapshot image I’m able to login with root using the new password, but I’m unable to log into MySQL using the login credentials I created within the snapshot image. I also tried using the new password for root generated when creating a new droplet.
The error message is: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Could you someone please help assist? The original droplet that I took the snapshot image that was used for the new droplet works perfectly fine when logging into MySQL with login credentials.
Thanks,
Troy
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
MySQL seems to be down – try starting it: <br> <br><pre>sudo service mysql start</pre>
Hi. I just tried the above, but the error message is saying: <br> <br>start: Job failed to start <br> <br>Do you know what might be the problem? <br> <br>Thanks, <br> <br>Troy
What’s the output of this command? <br> <br><pre>tail /var/log/mysql.err</pre>
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.