In the last episode (Jul 18), Matt said:
> 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).
It's an unfortunate side-effect of MIT-pthreads, which doesn't support
Unix-domain sockets. If you build mysql with MIT threads, mysqld will
not create a /tmp/mysql.sock, but for some reason the _clients_ (mysql
and mysqladmin) still insist on using it. Thus the error. you can get
around this by adding "-h localhost" to your client commandline.
The FreeBSD port of mysql builds with MIT-pthreads by default. Edit
the Makefile in the port dir, add "NATIVE_THREADS=YES", and rebuild.
-Dan Nelson
dnelson@stripped
