MYSQL_SOCkET vs. mysql.default_socket

MYSQL_SOCkET vs. mysql.default_socket

am 28.10.2008 09:08:20 von Hermann Giebels

Hello,

phpinfo shows two values for the socket location of mysql. One is called MYSQL_SOCKET, the other one, which I can define in the php.ini, is called mysql.default_socket.

Now I wonder where the first comes from and where or how to manipulate this. And what is the difference, which one has precedence? Why are there two settings at all?

Thanks for your help

Hermann
--
"Feel free" - 5 GB Mailbox, 50 FreeSMS/Monat ...
Jetzt GMX ProMail testen: http://www.gmx.net/de/go/promail

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: MYSQL_SOCkET vs. mysql.default_socket

am 29.10.2008 06:13:59 von dmagick

Hermann Giebels wrote:
> Hello,
>
> phpinfo shows two values for the socket location of mysql. One is called MYSQL_SOCKET, the other one, which I can define in the php.ini, is called mysql.default_socket.
>
> Now I wonder where the first comes from and where or how to manipulate this. And what is the difference, which one has precedence? Why are there two settings at all?



MYSQL_SOCKET is used if you specify 'localhost' as the server name. PHP
communicates via the socket instead of via tcp/ip in this case. This
might only look for socket files in standard locations.

If mysql.default_socket is specified, that is used instead of
MYSQL_SOCKET (eg the socket file is in a non-standard path like
/usr/local/mysql/ or something).

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php