Related
Join the DigitalOcean Community
Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
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
reading initial communication packet', system error: 0
I am getting the following error when trying to remotely connect to my MySQL server.
Unable to connect to host 127.0.0.1, or the request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
I am logging in using SSH: http://i.imgur.com/ljZflVG.png
Update 1#
I experience this on all of my Digital Ocean droplets (since 2014). Rebooting the server solves the problem. Sometimes I have to reboot the server several times before the error vanishes and I can log in.
Update 2#
It only happens through SSH login.
If I login using remote IP, user and password I can connect just fine.
Add a comment
Related
Join the DigitalOcean Community
Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
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
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.
×