MYSQL_SOCkET vs. mysql.default_socket

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
Hermann Giebels [ Di, 28 Oktober 2008 09:08 ] [ ID #1975099 ]

Re: MYSQL_SOCkET vs. mysql.default_socket

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?

<guess>

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
dmagick [ Mi, 29 Oktober 2008 06:13 ] [ ID #1975236 ]
PHP » gmane.comp.php.database » MYSQL_SOCkET vs. mysql.default_socket

Vorheriges Thema: MySQL Query Timeout program in PHP
Nächstes Thema: Help needed - SELECT query optimization