PHP-Mysql Socket Problem

[balavignesh]

Hello frends!

I want to connect with mysql using php.

In my mysql "my.cnf" file i have specified the socket for both client
and server as
"/usr/local/mysql/var/mysql.sock"

In my "php.ini" file, for mysql socket i have specified

/usr/local/mysql/var/mysql.sock as the default path.

But i can't able connect with database. it shows DB connection failed.
My phpinfo() gives the following two lines for mysql sock

MYSQL_SOCKET /tmp/mysql.sock
mysql.default_s ocket /usr/local/mysql/var/mysql.sock /usr/local/mysql/var/mysql.sock
If i set the socket as /tmp/mysql.sock in "my.cnf" , I CAN ABLE TO
CONNECT.

What is the difference between MYSQL_SOCKET and mysql.default_s ocket ?

Advanced thanks
Bala

[Andy Hassall]

On 7 Jul 2006 10:16:20 -0700, "balavignes h" <kb**********@g mail.comwrote:

I want to connect with mysql using php.

In my mysql "my.cnf" file i have specified the socket for both client
and server as
"/usr/local/mysql/var/mysql.sock"

In my "php.ini" file, for mysql socket i have specified

/usr/local/mysql/var/mysql.sock as the default path.

But i can't able connect with database. it shows DB connection failed.
My phpinfo() gives the following two lines for mysql sock

MYSQL_SOCKET /tmp/mysql.sock
mysql.default_ socket /usr/local/mysql/var/mysql.sock /usr/local/mysql/var/mysql.sock
If i set the socket as /tmp/mysql.sock in "my.cnf" , I CAN ABLE TO
CONNECT.

What is the difference between MYSQL_SOCKET and mysql.default_s ocket ?

MYSQL_SOCKET shown on phpinfo() appears to be the value specified in
"configure" via --with-mysql-sock.

It gets mapped onto the constant MYSQL_UNIX_ADDR , which is used in the mysql
module's phpinfo function.

But after looking through the rest of the source of the mysql module (in
5.1.4) it doesn't appear to be used anywhere else - only the configuration
option mysql.default_s ocket seems to be accessed, so it's that one you've got
to set.

--
Andy Hassall :: an**@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[balavignesh]

Andy Hassall wrote:

But after looking through the rest of the source of the mysql module (in
5.1.4) it doesn't appear to be used anywhere else - only the configuration
option mysql.default_s ocket seems to be accessed, so it's that one you've got
to set.

Thanks for ur clarification Andy...but,

If i set the default socket as "/usr/local/mysql/var/mysql.sock"
in php.ini
and
/etc/my.cnf ,

i can't able to connect.

it only works if i set /tmp/mysql.sock in both place.

what is the reason?

regards
Bala