Question
MySQL Doesn't respond on an DO LAMP instance
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?
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.
×
What IP address/interface is MySQL listening on?
If it’s set to
127.0.0.1
or any other IP address, you will need to explicitly specify it: