Question

MySQL Doesn't respond on an DO LAMP instance

Posted September 24, 2014 1.7k 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 127.0.0.1 or any other IP address, you will need to explicitly specify it:

    mysql -h 127.0.0.1 -uroot -p
    

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.

×
1 answer
Submit an Answer