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?