Warning: Can't connect to local MySQL server throu

Anon

My php script work correctly erery day but
some time it can't not work with sent back this
message

" Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) in file ... "

I don't know what's wrong with my script.

Can Anyone help me ??

Thanks a lot
Tongdee

Anon

Did you check to see if your database server is running when you get this error?

Anon

It's probably a file access error.

Have you checked if the socket file exists, where it is and if it's readable/writable for the user mysqld runs as? Have you tried to run the mysql client as root and a non-privileged user? If things go smoothly while running as root, but don't when running as a non-privileged user, it's DEFINITELY a file access problem. Otherwise, check the socket path in the file "my.cnf". (it's in /etc IIRC)

Everything seems to run smoothly when you build mysql from source, defining both the mysql user and the socket file when configuring make, and editing my.cnf to point to the socket file. Works for me.

-j

Anon

UUUUPs I found the problem, it seems that my "mysql" executable was empty it was an empty file inside my /usr/local/mysql/bin folder the actual executable had been moved to /root/Descktop/Trash/mysql/bin/

aparently the system moved it there when my file system crashed a few weeks back.

I copyed the file back to it's original place and it is working fine!

Thank for the Help in the Forum.

Anon

had the same prob turns out if you don't include the right socket libs under linux it links the socket routines
in mysql to the wrong ones arg!! make sure you have the following includes
#include <netdb.h>
#include <netinet/in.h>

Anon

Hi,

I'm getting the same problem in that I can't even start mysql server when I run "mysql". Any suggestions.

Carlos.