Re: Connecting PHP to MySQL on Windows

[michael manning <michaelgmanning@xxxxxxxxx>]

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/
>