Error: #2002 - my.cnf causing my head to ache.

[Muuss]

in your my.cnf, replace /var/lib/mysql/mysql.sock by /tmp/mysql.sock
for the client and the mysqld options. /var/lib is the default option when you compile/install it yourself. it's easier to have it in /tmp since most softwares using mysql search it in /tmp .

Once you modified your my.cnf, don't forget to kill and spawn again mysqld (mysql_safe... etc)