Mysql: ERROR 2002: Can't connect to local MySQL server throughsocket '/tmp/mysql.sock'

[John Brooks]

seems like your problem is that mysqld will not start, in
order to start it must be able to read the files that make
up your databases. the directories that hold these files 
can only be read by the user 'mysql' (look at the directory
permissions). mysql uid is normally '88'. you may have other
problems also, but until you fix this they cannot be addressed

hint:  look at the start up script in /usr/local/etc/rc.d
       to see how to start the daemon as the user 'mysql',
       (file name should be something like 'mysql-server.sh')

--
John Brooks
john at day-light.com 

... 
 kernel: pid 27201 (mysqld), uid 10**: exited on signal 6
 
 (which is a sigabort)
...