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.