Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

I have errors with logging into mysql ser

Posted September 6, 2019 242 views
MySQL

I installed mysql server yesterday on my droplet, it worked properly yesterday but today I tried logging into the mysql $ mysql -u root -p and it throws an error (ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/var/run/mysqld/mysqld.sock’ (2) ).

Please I need help with this, it’s my first time deploying on digital ocean and I don’t know how to solve this particular issue, all help from the internet seem not to work and I’m pressured for time to get it working, please help me.

thanks.

Add a comment
davezaghadon
By:
davezaghadon
Add a comment

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.

×
1 answer
bobbyiliev September 6, 2019

Hello,

You would need to make sure that MySQL is up and running before you could access it. To check the current status run:

systemctl status mysql

Then if the service is not active, you can start it with:

systemctl start mysql

After that you should be able to login as normal.

Hope that this helps!
Regards,
Bobby

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help