-1

I have been doing some work with MySQL recently and needed to use InnoDB. I checked to see if it was installed and switched on using: mysqladmin variables | grep have_innodb. It said no so i went into /etc/mysql/my.cnf and commented out –skip-innodb

After i restarted and tried to log in I am getting the following issue:

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

Improve this question
3
  • When you say you tried to log in, how are you doing it? Command-line mysql or via another application? Commented Aug 20, 2012 at 19:06
  • Is your client and server expecting the same socket? (socket option in the configuration files) Commented Aug 21, 2012 at 8:48
  • did you check the mysql logs for errors while starting? Commented Aug 21, 2012 at 8:48

1 Answer 1

Reset to default
2

The error that you are seeing is most likely caused by the mysqld service not running. You can test this with

service mysqld status mysql start/running, process 13632

or more likely in your case

service mysqld status mysql stop/waiting

There are many reasons why your mysql might not be running, you'll most likely find more information about why in the error log /var/log/mysql/error.log

Improve this answer

You must log in to answer this question.