MySQL Doesn't respond on an DO LAMP instance

September 24, 2014 685 views

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?

1 comment
  • What IP address/interface is MySQL listening on?

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

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

    mysql -h -uroot -p
1 Answer
Have another answer? Share your knowledge.