MySQL working with 127.0.0.1 but not working with

Question

I have a strange problem in php MySQL:

php connects with 127.0.0.1 but not with localhost.

How to solve this issue?

Answer 1

Try ping localhost in a command line, it may be resolving to ::1: the IP6 equivalent to 127.0.0.1

To fix it, add (or uncomment) the line:

   127.0.0.1       localhost

in C:\WINDOWS\system32\drivers\etc\hosts

Answer 2

Is localhost resolving to the IPv6 address, as opposed to the IPv4, and MySQL is not listening on the v4 address?

The solution is make localhost resolve to the v4 address, OR make MySQL listen on the v6 address.

Answer 3

I remember that being a longstanding and documented feature of Mysql on Windows. Something about the way local sockets work or something.