Question

Creating New Droplet using Snapshot Image (MySQL connection issues)

Posted August 24, 2013 6.7k views
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
Add a comment
troy
By:
troy

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.

×
Submit an Answer
6 answers
kamaln7 August 24, 2013
MySQL seems to be down -- try starting it: 

sudo service mysql start
Reply Report
troy August 24, 2013
Hi. I just tried the above, but the error message is saying:

start: Job failed to start

Do you know what might be the problem?

Thanks,

Troy
Reply Report
kamaln7 August 24, 2013
What's the output of this command? 

tail /var/log/mysql.err
Reply Report
troy August 24, 2013
Figured it out. I forgot to change the bind IP address within the /etc/MySQL/my.cnf file. For those learning like me you can run the following code. Please keep in mind security issues when using the steps below, this only for learning purposes.

sudo nano /etc/MySQL/my.cnf

Go to the line that says "bind-address" and change the IP address to your new droplet server IP address.

Cheers,

Troy
Reply Report
kamaln7 August 24, 2013
You can just set it to 127.0.0.1 so it would listen on the local interface, or 0.0.0.0 if you want it to listen on all interfaces.
Reply Report
troy August 24, 2013
Ok, thanks.
Reply Report

Looking for something else?

Ask a new question Search for more help