Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"

From:	kiewic at gmail dot com	Date:	Tue, 11 May 2010 06:30:32 +0000
Subject:	Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-150317@lists.php.net to get a copy of this message

Edit report at http://bugs.php.net/bug.php?id=45150&edit=1

 ID:               45150
 Comment by:       kiewic 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)

 New Comment:

Same problem with Windows Vista Ultimate SP2. Why isn't this a bug?


Previous Comments:
------------------------------------------------------------------------
[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.

------------------------------------------------------------------------
[2010-03-05 20:51:16] pajoye@php.net

That's not a bug, please refer to the dozen other reports about that.

------------------------------------------------------------------------


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


   

Thread (21 messages)

• conor dot kerr_php at dev dot ceon dot netMon, 02 Jun 2008 16:46:50 +0000
  • conor dot kerr_php at dev dot ceon dot netFri, 13 Jun 2008 14:09:04 +0000#45150 [Opn]: MySQL functions cannot be used with 5.3.x on Vista
  • jani@php.netSun, 13 Jul 2008 15:05:56 +0000#45150 [Opn->Fbk]: MySQL functions cannot be used with 5.3.x on Vista
  • conor dot kerr_php at dev dot ceon dot netFri, 18 Jul 2008 07:46:36 +0000#45150 [Fbk->Opn]: MySQL functions cannot be used with 5.3.x on Vista
  • conor dot kerr_php at dev dot ceon dot netFri, 18 Jul 2008 16:54:56 +0000#45150 [Opn]: MySQL functions cannot be used with 5.3.x on Vista
  • andrey@php.netWed, 23 Jul 2008 11:24:54 +0000#45150 [Opn->Fbk]: MySQL functions cannot be used with 5.3.x on Vista
  • conor dot kerr_php at dev dot ceon dot netWed, 23 Jul 2008 13:03:04 +0000#45150 [Fbk->Opn]: MySQL functions cannot be used with 5.3.x on Vista
  • conor dot kerr_php at dev dot ceon dot netWed, 23 Jul 2008 13:27:36 +0000#45150 [Opn->Csd]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • "Fri, 05 Mar 2010 19:46:39 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • pajoye@php.netFri, 05 Mar 2010 19:51:16 +0000Bug #45150 [Csd->Bgs]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • achurkin at gmail dot comTue, 16 Mar 2010 12:55:29 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • telstra at dark-media dot netMon, 05 Apr 2010 05:52:31 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • buana95 at yahoo dot comSat, 10 Apr 2010 01:58:16 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • sasavilic at gmail dot comMon, 19 Apr 2010 02:13:09 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • kiewic at gmail dot comTue, 11 May 2010 06:30:32 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • andrey@php.netTue, 06 Jul 2010 17:10:38 +0000Bug #45150 [Bgs]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • songchongzhan at gmail dot comMon, 06 Sep 2010 06:51:41 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • uw@php.netMon, 06 Sep 2010 09:18:21 +0000Bug #45150 [Bgs]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • zarlean at yahoo dot comSat, 11 Sep 2010 14:32:19 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • iswald at yahoo dot comMon, 18 Oct 2010 23:39:25 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
  • slava at shabrov dot comTue, 16 Nov 2010 03:18:31 +0000Bug #45150 [Com]: MySQL functions cannot be used with 5.3.x on Vista when using "localhost"