Can't connect

Yes I've been to mysql.com but
i'm still getting the error Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
I checked the mysql.sock file and it is empty
- any one got any idea whats happening - i have installed this on my machine at home and it works perfectly.

Os Red Hat Linux 5.2

thanks in advance

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by des:
Yes I've been to mysql.com but
i'm still getting the error Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
I checked the mysql.sock file and it is empty
- any one got any idea whats happening - i have installed this on my machine at home and it works perfectly.

Os Red Hat Linux 5.2

thanks in advance[/quote]

Hi,

If you can find file mysql.sock, and can't connect to mysql, it means that your client can't find the sock. Try calling the client with the option --socket=socket_path/mysql.sock .

ex. mysql --socket=/usr/local/mysql/mysql.sock

If it works, check the file /etc/my.cnf and change the [client] section so that the socket file is pointed to the same address as the socket in [mysqld] section.

Please e-mail if I haven't been very clear.


Bye,

G.Bubani

Hi,


Hi G.Bubani

Thank you for you reply - I have tried what you have said but it still doesn't connect. The mysql.sock that is there is empty (zero k). I have reinstalled but still nothing - can I get a mysql.sock file or is one created for each individual machine?

thanks again for your help

Des

Ps I'm going to do another reinstall

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by des:
Hi,


Hi G.Bubani

Thank you for you reply - I have tried what you have said but it still doesn't connect. The mysql.sock that is there is empty (zero k). I have reinstalled but still nothing - can I get a mysql.sock file or is one created for each individual machine?

thanks again for your help

Des

Ps I'm going to do another reinstall
[/quote]

Hi Des,

The file mysql.sock is a temporary file created as the deamon starts and is deleted as the daemon stops.

Can you tell me where your mysql.sock is, and what permissions (owner, group, rxw) does the directory has so that I can think about what is going on ?

Bye

G.Bubani

Hi G.Bubani
It looks for the file at
/var/lib/mysql/mysql.sock

but I have var/lib -but no mysql directory

permissions for both var and lib are
drwxr-xr-x

thanks
Des

Apologies G.Bubani


Please ignore last message I have a mysql directory in /var/lib/
With permissions of drwxr-xr-x

Thanks
Des

Hi G.Bubani

Its a server problem I spoke with our server people and they have it working now.
Thank you for all of your help
Des