Matt wrote:
>
> I've installed the mysql port on a freeBSD 3.2-stable box... It now crashes
> with:
>
> 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
>
> --<M@>--
> Matt Cummings
> http://www.adslisp.net/
> ISP support for DSL
>
Let's do some tests:
killall mysqld
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:
/path/to/safe_mysqd &
make sure to replace /path/to with the actual path
You should get a message about mysqld starting.
then:
netstat -an | grep 3306
You should see something like this:
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN
mysql -h `hostname` and you should connect
if you get that far,
try
mysql
and see if you connect
post the results
--
Sasha Pachev
http://www.sashanet.com
