I've been struggling with this issue for a really long time. Can someone please advise me on how to get mysql working?
root@me:~# start mysql
start: Job is already running: mysql
root@me:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
What boggles the mind is that it shows no mysql processes being run even though the above bash says otherwise.
~# ps -ef | grep mysql
root 8968 1631 0 15:24 pts/0 00:00:00 grep --color=auto mysql
/var/run/mysqld/mysqld.sock
Delete it. It is a stale socket file. Then try to start.