Hello,
For that error, the sock file is what we want to look at.
For FreeBSD/Debian, it will be /tmp/mysql.sock.
For all other OS's, it should be /var/lib/mysql/mysqld.sock
And since your error is referring to /var/run/mysqld/mysqld.sock.. which isn't one of those 2 paths, I would then assume that there is a my.cnf somewhere causing problems, changing the location.
1) make sure you don't have:
/etc/init.d/mysql
It should be:
/etc/init.d/mysqld
with a d at the end. If you have 2.. delete the one without the d.
If the "mysql" had booted mysql, it may have command line options telling mysqld to create the sock file somewhere else on the system.
2) check for /etc/my.cnf. If you have that, edit it.. check for any mysql.sock paths, and ensure they're all set to use /var/lib/mysql/mysqld.sock (or /tmp/mysql.sock).
Have no values set in there is fine, it will default to the correct place.
Anyway, once you've confirmed it's all good.. try
Code:
killall -9 mysqld mysqld_safe
/etc/init.d/mysqld start
and then give it another go.
Check to see where your sock actually lives
John