Can't connect Can anyone help

Anon

Hello I have a problem connecting to my MYSQL database. I have a form that passes two variables to a select query in my .php3 page and I get the following:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in
/home/httpd/html/test/fichedb/Fische.php on line 22

When I telnet into that box I do a mysqladmin version and it show that the UNIX socket is /var/lib/mysql/mysql.sock

I also login into mysql and try to run my select it works like a champ.....I am so stumped....I don't know what else to try any suggestions?

Anon

You complied PHP before you installed mysql. Goto /tmp and type the following command

ln -s /var/lib/mysql/mysql.sock mysql.sock

That will create a symbolic link from /tmp/mysql.sock to /var/lib/mysql/mysql.sock and will correct the problem you are having. Either that, or recompile php.. this way is just quicker.

Hope that helps.

Chris King

Anon

Chris, I want to say thank you. I have beenn up all night (yep, literally all night working on this) and this message solved all of my problems. What is more it is the only place I found this information. It is not in the FAQ's or anythig. I have now forwarded a copy of this message to the PHP team, asking that tehy include it within the FAQ as think it invaluable!

Chris King wrote:

You complied PHP before you installed mysql. Goto /tmp and type the following command

ln -s /var/lib/mysql/mysql.sock mysql.sock

That will create a symbolic link from /tmp/mysql.sock to /var/lib/mysql/mysql.sock and will correct the problem you are having. Either that, or recompile php.. this way is just quicker.

Hope that helps.

Chris King

Anon

I'm having the same problem. Tried your suggestions but it still won't connect. /tmp/mysql.sock exists, I even tried removing it and making a soft link to the version under var..

still doesn't work. any idea? like Mark, I've been pulling hair all night long.

here's how I'm trying to talk to mySQL

$db = mysql_connect("localhost", "root");
mysql_select_db("Gismo",$db);

Anon

Chris you are a lifesaver. I spent the entire evening hunting around for this info. It's always the little things that get you.

Thanks again!