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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.