Posted by balavignesh on 07/07/06 17:16

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_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_socket ?

Advanced thanks
Bala

[Back to original message]