So I installed MySQL using yum install mysql on an Amazon EC2 Micro instance using the Basic 64-bit Amazon Linux AMI 2010.11.1 Beta AMI. I try to connect to MySQL using the command mysql but I get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I can't understand why this is happening. I seem to be the same as this question here. What can I do?


The server may not be installed, try

yum install mysql-server

it will start as part of the installation process. Use

chkconfig mysqld on

to have the server run after a reboot.

  • Ha, didn't install the mysql-server part. Good catch, thanks a bunch. – Chiggins Feb 21 '11 at 1:33
  • No problem, easy mistake to make :) – Andy Feb 21 '11 at 12:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.