> I've installed the mysql port on a freeBSD 3.2-stable box... It now crashes
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
> The socket isn't even being created (/tmp/ is empty).
> The server has been deinstalled, recompiled, reinstalled, etc. Just for
> paranoia. It has been tested, running as root, and the problem still occurs.
> I do have a process running for the server and I can telnet to the server
> and get the version number.
> I'm a newbie to the unix world so please be gentle if this problem has an
> easy fix that I should have been able to figure out :) --Thanks
> Matt Cummings
> ISP support for DSL
Let's do some tests:
just to be sure we are not running any mysqld instances
find / -name safe_mysqld -print 2>/dev/null
It should print a full path to safe_mysqld
then use the stuff that it prints:
make sure to replace /path/to with the actual path
You should get a message about mysqld starting.
netstat -an | grep 3306
You should see something like this:
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
mysql -h `hostname` and you should connect
if you get that far,
and see if you connect
post the results