Re: Connecting PHP to MySQL on Windows

Mike, A plain HOST file should have the commented part at the top, and only 1 reference to localhost unless you are creating Virtual hosts. I would suggest removing the "::1" line BR Gavin On Fri, Jan 7, 2011 at 4:18 AM, michael manning <michaelgmanning@gmail.com>wrote: > Hi, > > I swapped out 'localhost" for '127.0.0.1' in the url but this had no > effect. > > I had a look at my hosts file at c:\windows\system32\drivers\etc and this > contained: > > # Copyright (c) 1993-2006 Microsoft Corp. > # > # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. > # > # This file contains the mappings of IP addresses to host names. Each > # entry should be kept on an individual line. The IP address should > # be placed in the first column followed by the corresponding host name. > # The IP address and the host name should be separated by at least one > # space. > # > # Additionally, comments (such as these) may be inserted on individual > # lines or following the machine name denoted by a '#' symbol. > # > # For example: > # > # 102.54.94.97 rhino.acme.com # source server > # 38.25.63.10 x.acme.com # x client host > > 127.0.0.1 localhost > ::1 localhost > > and so this seems fine as well. > > cheers > > Mike > > On Fri, Jan 7, 2011 at 1:25 PM, Daniel Brown <danbrown@php.net> wrote: > > > On Thu, Jan 6, 2011 at 21:12, michael manning <michaelgmanning@gmail.com > > > > wrote: > > > Hi Daniel, > > > When testing with the CLI, netstat shows: > > [snip!] > > > > What happens when you swap out 'localhost' for '127.0.0.1' in the > > connection routine? If that works, check to make sure your hosts file > > properly designates 127.0.0.1 as 'localhost' (by editing > > c:\windows\system32\drivers\etc\hosts I believe.... been a while since > > I've done it on Windows). > > > > -- > > </Daniel P. Brown> > > Network Infrastructure Manager > > Documentation, Webmaster Teams > > http://www.php.net/ > > > -- Best regards, Gavin C