MySQL on Windows-7 (64-bit) on 0.0.0.0:3306 rather than 127.0.0.1:3306
- by Mark Baker
I've just installed the latest production release of MySQL (64-bit) on my Windows 7 box. It was a straight vanilla install, using all defaults; but phpmyadmin can't see it at all.
MySQL is configured as a service to start automatically, and I know it's running because the MySQL GUI tools work correctly.
Doing a netstat -a, I see
TCP 0.0.0.0:3306 Marks-Netbook:0 LISTENING
when I'd expect to see
TCP 127.0.0.1:3306 Marks-Netbook:0 LISTENING
I don't know if this is the reason phpmyadmin can't connect, but suspect that it is probably the case.
Can anybody confirm whether this is the likely cause, and/or suggest how I can reso;lve this?