MySQL localhost slow connection on IIS 8

iis-8MySQLPHPwindows-server-2012

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

Add 127.0.0.1 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 127.0.0.1 it needs 0.0001 seconds.

Best Answer

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)

Related Solutions

Linux – remote Mysql connections taking 5 seconds to establish

Huh. Interesting issue.

Take a look to /etc/nsswicth.conf - this file determines order of looking in system databases (users, passwords, hosts, etc). hosts: line should look like hosts: files dns <everything else>. You could also try to remove <everything else>.

Mysql – can’t connect to MySQL from localhost on Centos 5

Just for the sake of ruling MySQL is the culprit, please make sure you have root@localhost and root@127.0.0.1 as separate users defined in MySQL.

Do the following to make sure root users can come into MySQL:

SHOW GRANTS FOR 'root'@'localhost';
SHOW GRANTS FOR 'root'@'127.0.0.1';

root@localhost connects via the mysql.sock file

root@l127.0.0.1 connects via TCP/IP

Until you get the networking issues straightened out, you may want to use the --protocol option of the mysql client to specify the protocol (tcp,socket,pipe,memory)

Best Answer

Related Solutions

Linux – remote Mysql connections taking 5 seconds to establish

Mysql – can’t connect to MySQL from localhost on Centos 5

Related Topic