I already had this issue on my Windows 2008 Server and I was able to solve it the following way:

  • Add localhost to Windows hosts file
  • Add skip-name-resolve to my.ini

It's very weird that on Windows Server 2012 (IIS8) these tricks don't help.

Creating a connection using PHP/MySQLi to MySQL needs 1 seconds when using localhost as server name, to it needs 0.0001 seconds.

  • Sounds like it's querying your DNS server for the hostname anyway (although the hosts entry should prevent that). Try logging DNS lookups to see if this is the case. – Oldskool Dec 28 '12 at 15:05

Set HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters\DisabledComponents DWORD (32-bits) in your registry to the value 0x20 and then reboot the computer to prefer ipv4 above ipv6 (Reference: http://support.microsoft.com/kb/929852)

  • Silly me, I should have known that... lol. Thank you for showing me that, I will try it out. – andreas May 3 '13 at 22:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.