problem with "mysql.sock" file

Hi,

I installed mysql 5.0 on redhat 9.0 from source (tar).
The whole procedure occured properly, i could do ./mysqld_safe.
But when i want to start the client: mysql, i get :error 2002: cannot
connect to mysql server through 'tmp/mysql.sock'.

I set /tmp with the sticky bit, because otherwise file 'mysql.sock' woukd be
deleted !?.
I also created 'my.cnp into /etc, but my problem is that there is no file
'mysql.sock'.

I recompiled it again (make, make install) but still no file 'mysql.sock'
anywhere.

How can i create or get such a file?
Thanks
ben

Re: problem with "mysql.sock" file

"Ben" wrote in message
news:jpSdndunreGbbjLeRVnyrQ@scarlet.biz...
> But when i want to start the client: mysql, i get :error 2002: cannot
> connect to mysql server through 'tmp/mysql.sock'.

See my reply to your posting on comp.databases.mysql.

Quick suggestion for troubleshooting this error:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-se rver.html

Regards,
Bill K.

Re: problem with "mysql.sock" file

Ben wrote:
> Hi,
>
> I installed mysql 5.0 on redhat 9.0 from source (tar).
> The whole procedure occured properly, i could do ./mysqld_safe.
> But when i want to start the client: mysql, i get :error 2002: cannot
> connect to mysql server through 'tmp/mysql.sock'.
>
> I set /tmp with the sticky bit, because otherwise file 'mysql.sock' woukd be
> deleted !?.
> I also created 'my.cnp into /etc, but my problem is that there is no file
> 'mysql.sock'.
>
> I recompiled it again (make, make install) but still no file 'mysql.sock'
> anywhere.
>
> How can i create or get such a file?
> Thanks
> ben
>
>
>
>

the mysql.sock is created by the server process upon starting. try
starting the server from the 'services' gui utility as opposed to
command line.
good luck