Question

MySQL Doesn't respond on an DO LAMP instance

  • Posted September 24, 2014

I’ve been a mysql user for years, but I can’t seem to use mysql on a droplet made from your LAMP image. Here i entered the password given in the motd, but the error is the same without the -p flag.

root@myhost:~# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I can see the mysqld process running, but I can’t login.

using the --port flag with the 3306 gets the same result.

is there a reason that mysql is configured like this?

Subscribe
Share

What IP address/interface is MySQL listening on?

sudo grep bind-address /etc/mysql/my.cnf

If it’s set to 127.0.0.1 or any other IP address, you will need to explicitly specify it:

mysql -h 127.0.0.1 -uroot -p

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

i see - that’s it!