Edit report at http://bugs.php.net/bug.php?id=48082&edit=1
ID: 48082 Comment by: dex_is_cool at loopmod dot com Reported by: andrew dot answer at gmail dot com Summary: mysql_connect does not work with named pipes Status: Assigned Type: Bug Package: MySQL related Operating System: win32 only - Windows XP PHP Version: 5.3.0RC1 Assigned To: mysql New Comment: I can't get named pipes working. It _always_ falls back to TCP, and fails if it can't get TCP connection. Windows XP sp3 IIS 5.1 FastCGI php-5.3.2-nts-Win32-VC9-x86 Previous Comments: ------------------------------------------------------------------------ [2010-02-17 20:11:16] quakvorgus at yahoo dot com Confirming what andrew wrote. @kulakov74: Thanks for the information. Setting mysql.default_socket = mysql does not solve the issue for me. Will have to switch to tcp connections instead of using named pipes. Please, the official documentation should be updated about this change from php 5.2 to 5.3. ------------------------------------------------------------------------ [2010-02-02 07:07:14] peaceable_whale at hotmail dot com I have the same problem using PHP 5.3.1 on IIS 7.5 w/FastCGI and MySQL 5.1.43. Is there any update on this issue? ------------------------------------------------------------------------ [2009-10-20 19:56:25] kulakov74 at yandex dot ru I confirm this with the just installed PHP 5.3.0 on Win XP, I used to use pipes and had skip-networking in my my.ini, I still can connect with mysql.exe, but PHP does not connect this way any more - I had to comment out skip-networking and set the right port in mysql.default_port = 3306 (PHP used to work without it when I used TCP long ago). Yes, the dot does not work any more, as if it cannot be resolved to localhost. If I have mysql.default_socket = mysql in my php.ini, mysqlnd connects to localhost via UNIX socket, otherwise it uses TCP. I agree these things are not critical, yet they have to be mentioned or explained somewhere. Got some info on pipes here: http://blog.ulf-wendel.de/?p=157 (comments) ------------------------------------------------------------------------ [2009-06-29 09:43:02] andrew dot answer at gmail dot com http://stackoverflow.com/questions/832714/mysql-named-pipes-on-windows- faster-best-practice-or-bad-idea ------------------------------------------------------------------------ [2009-06-29 09:40:48] andrew dot answer at gmail dot com regarding performance http://www.google.ru/search? rlz=1C1GGLS_ruRU305RU305&sourceid=chrome&ie=UTF-8&q=named+pipes+speed http://www.mail-archive.com/my...@lists.mysql.com/msg77837.html http://msdn.microsoft.com/en-us/library/aa178138(SQL.80).aspx ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=48082 -- Edit this bug report at http://bugs.php.net/bug.php?id=48082&edit=1
