Hi, Thanks to everyone who assisted me. Removing the line: ::1 localhost from the c:\windows\system32\drivers\etc\hosts file did the trick and allowed me to access MySQL databases without any problems. I confirmed this was the correct solution by re-adding the line and seeing it fail again, removing the line again and successfully connecting. So the problem was nothing to do with Apache, PHP or MySQL directly but was a local networking issue. Of course, the hosts file on my working Windows XP computer at home did not have this line in the hosts file Many thanks again. Mike michaelgmanning@xxxxxxxxx On Sat, Jan 8, 2011 at 7:06 AM, Gavin Chalkley <gavin.chalkley@xxxxxxxxx>wrote: > 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@xxxxxxxxx>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@xxxxxxx> wrote: > > > > > On Thu, Jan 6, 2011 at 21:12, michael manning < > michaelgmanning@xxxxxxxxx > > > > > > 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 >
