I had the same problem and what I did is located the mysql.sock which was
located in /var/lib/mysql/mysql.sock
and then I just created a sym link from the temp dir and it worked fine.
ln -s /var/lib/mysql/mysql.sock mysql.sock
mysql.sock -> /var/lib/mysql/mysql.sock
Mike
-----Original Message-----
From: Eric Persson [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 8:28 AM
To: Marek Mahdal; [EMAIL PROTECTED]
Subject: Re: mysql.sock
Marek Mahdal wrote:
>
> Hi,
> I have a problem with MySQL.
> I am running Redhat Linux 6.1, MySQL 3.23.38 and PHP 4.0.
> The command line client mysql is working perfectly. But if i try to
connect to the MySQL server from a web site using PHP I get this error
message:
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111) in
/web/domains/allegro-viatatry/index.php on line 3
>
> In the index.php I am using the same code I used on other machine, with
the same parameters, and it worked. I looked into the /tmp directory. There
is no file named
> 'mysql.sock'.
>
> Please help.
>
> Thank you. Marek Mahdal, Slovakia
Hi !
Try locating your mysql.sock file, depending on your mysqlinstallation
method and parameters its placed on different places.
I guess it could be in /usr/local/mysql/var/mysql.sock but try "locate
mysql.sock" in the shell.
Where the default mysql.sock is located by php can be set in php.ini i
think, otherwise you could supply som extra values to mysql_connect().
I think its mysql_connect("localhost:/usr/local/mysql/var/mysql.sock"),
but check the manual to be sure.
Good luck!
Eric
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
