After install Mysql,where is the mysqld.sock ?

sbw#./mysqlbug

>Release: mysql-3.23.21-beta (Source distribution)

>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD sbw.freebsd.com.cn 3.2-RELEASE FreeBSD 3.2-RELEASE #0: Tue May 1
8 04:05:08 GMT 1999 jkh@cathair:/usr/src/sys/compile/GENERIC i386


Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1043748 May 18 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Mar 4 15:44 /usr/lib/libc.so -> libc.so.3
-r--r--r-- 1 root wheel 514015 May 18 1999 /usr/lib/libc.so.3
Configure command: ./configure --prefix=/usr/local/mysql --with-unix-socket-pat
h=/usr/local/mysql/tmp/mysql.sock
Perl: This is perl, version 5.005_03 built for i386-freebsd
~

***************************************************************
sbw# ./mysqladmin version
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/usr/local/mysql/tmp
/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/usr/local/mysql/tmp/mysql.so
ck' exists!
****************************************************************

I saw the manaul,but i have no way to try it.
The mysqld.sock is not there.After i installed it,i didn't see it.
I don't know where it goes.


cheers,
shan baowei
sbwtxj@263.net
sbwtxj@sina.com

------------------

The default is for it to be created in /tmp/mysql.sock. It is created by the daemon when you launch, NOT at install. It is destroyed when you shutdown
(using mysqladmin shutdown).

I had a lot of problems with this at first. The official solution is to simply use a binary distribution, which apparently doesn't have the problem of the missing socket.

I tried that, but wanted the flexibility of my own compile. My solution was to totally remove both the mysql program and the source files (though you might achieve the same by deleting config.cache and your make file, I wanted to be absolutely sure). Then I recompiled, explicity specifying the socket location as a config parameter. It's worked flawlessly since.

Cheers
Tom

try this it may work

/etc/inet.d/mysql start

or else

the path to mysqld/mysqld &

eg.
/usr/local/bin/mysqld &

Just a few things:

In the mysql-3.2x/scripts directory:

1. Make sure you run the mysql_install_db script from the distribution.

2. run safe_mysqld

Hope this helps.