Bug #45150 [Bgs]: MySQL functions cannot be used with 5.3.x on Vista when using localhost
Edit report at http://bugs.php.net/bug.php?id=45150edit=1 ID: 45150 Updated by: u...@php.net Reported by:conor dot kerr_php at dev dot ceon dot net Summary:MySQL functions cannot be used with 5.3.x on Vista when using localhost Status: Bogus Type: Bug Package:MySQL related Operating System: Windows Vista PHP Version:5.3CVS-2008-07-23 (snap) Block user comment: N New Comment: Bogus AKA duplicate http://bugs.php.net/bug.php?id=48082 Previous Comments: [2010-09-06 08:51:40] songchongzhan at gmail dot com Did you disable networking on windows. I use MySQL Query Browser connect to MySQL, it has MySQL Error Number 2003. Use mysqli connect to MySQL, it return like what you post:[2002]. And I use named pipe connect to MySQL by MySQL Query Browser, it is OK, by php 5.3.x does not support it util now. Try to open MySQL network connection. [2010-07-06 19:10:38] and...@php.net PLEASE READ THIS : http://blogs.iis.net/donraman/archive/2010/06/11/php-5-3-and-mysql-connectivity-problem.aspx [2010-05-11 08:30:30] kiewic at gmail dot com Same problem with Windows Vista Ultimate SP2. Why isn't this a bug? [2010-04-19 04:13:08] sasavilic at gmail dot com I have same issue. Using Windows 7, 64-bit, IIS When I try to connect to mysql server on 127.0.0.1 everything works fine, but with localhost not. [2010-04-10 03:58:16] buana95 at yahoo dot com Same issue on Windows XP SP3 and PHP 5.3.1 with mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $. Work fine when using *libmysql.dll, but can not connect to database when using *mysqlnd.dll (tested on mysql, mysqli, and PDO extension). *** From MySQL website: they have resolved the issue by looping to all available IP (IPv4 - IPv6) and return the first successful connection. So, it's must be from PHP streams that fail to resolve IPv6. Never test on newer PHP version. Sorry. 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=45150 -- Edit this bug report at http://bugs.php.net/bug.php?id=45150edit=1
Bug #45150 [Bgs]: MySQL functions cannot be used with 5.3.x on Vista when using localhost
Edit report at http://bugs.php.net/bug.php?id=45150edit=1 ID: 45150 Updated by: and...@php.net Reported by: conor dot kerr_php at dev dot ceon dot net Summary: MySQL functions cannot be used with 5.3.x on Vista when using localhost Status: Bogus Type: Bug Package: MySQL related Operating System: Windows Vista PHP Version: 5.3CVS-2008-07-23 (snap) New Comment: PLEASE READ THIS : http://blogs.iis.net/donraman/archive/2010/06/11/php-5-3-and-mysql-connectivity-problem.aspx Previous Comments: [2010-05-11 08:30:30] kiewic at gmail dot com Same problem with Windows Vista Ultimate SP2. Why isn't this a bug? [2010-04-19 04:13:08] sasavilic at gmail dot com I have same issue. Using Windows 7, 64-bit, IIS When I try to connect to mysql server on 127.0.0.1 everything works fine, but with localhost not. [2010-04-10 03:58:16] buana95 at yahoo dot com Same issue on Windows XP SP3 and PHP 5.3.1 with mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $. Work fine when using *libmysql.dll, but can not connect to database when using *mysqlnd.dll (tested on mysql, mysqli, and PDO extension). *** From MySQL website: they have resolved the issue by looping to all available IP (IPv4 - IPv6) and return the first successful connection. So, it's must be from PHP streams that fail to resolve IPv6. Never test on newer PHP version. Sorry. [2010-04-05 07:52:30] telstra at dark-media dot net Had the same problem on Windows Server 2008 R2 had to edit the hosts file and un comment out the 127.0.0.1 localhost Was stumbled for a while after upgrading from 5.2 to 5.3, this might not be a bug with PHP but its something that is going to cause issues. [2010-03-16 13:55:28] achurkin at gmail dot com Same on Windows 7 Home Edition. In PHP version 5.2.9 on same system everything works fine. 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=45150 -- Edit this bug report at http://bugs.php.net/bug.php?id=45150edit=1