Edit report at http://bugs.php.net/bug.php?id=45150&edit=1
ID: 45150
Comment by: songchongzhan at gmail dot com
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:
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.
Previous Comments:
------------------------------------------------------------------------
[2010-07-06 19:10:38] andrey@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.
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
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=45150&edit=1