{"id":4519,"date":"2015-04-13T14:32:52","date_gmt":"2015-04-13T06:32:52","guid":{"rendered":"http:\/\/rmohan.com\/?p=4519"},"modified":"2015-04-13T14:32:52","modified_gmt":"2015-04-13T06:32:52","slug":"disable-ipv6-on-windows","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=4519","title":{"rendered":"disable ipv6 on windows"},"content":{"rendered":"

MySQL client\u00a0fails to\u00a0connect to\u00a0localhost on Windows, due to IPv6<\/strong>
\nA MySQL client running on Windows 2008 or Windows 7 may fail to\u00a0connect to\u00a0the host name of “localhost”. This is due to windows resloving the host name of localhost to the IPv6 loopback address of ::1. Windows will resolve localhost to ::1, even if IPv6 is disabled on all local network adapters.<\/p>\n

MySQL IPv6 status<\/strong>
\nMySQL Server version\u00a05.5.3 (March 2010) and later, support IPv6 connections to localhost, using the ::1 IPv6 address. So recent\u00a0MySQL installations can at least listen for IPv6 client connections. But previous versions of MySQL server interpret ::1 as a string or host name, rather than an IP address.<\/p>\n

On the client software side, things are not as simple.
\nWe have the official MySQL Connector client libraries of connector\/j, connector\/odbc, connector\/net, connector\/c, connector\/c++, connector\/mxj, and the MySQL-PHP native driver (mysqlnd).\u00a0On PHP we have ext\/mysql,\u00a0mysqli and pdo_mysql. ColdFusion\u00a0uses its own MySQL client, with a different version of that client in each version of ColdFusion (mx, 7, 8, 9). Then there are\u00a0many third party\u00a0MySQL client libraries for Perl, ASP.Net, etc, etc, etc.<\/p>\n

You just can’t trust the client to support IPv6.\u00a0Only a few MySQL client libraries currently\u00a0support IPv6 connections, and of those that do support IPv6, only the most recent versions may properly support IPv6.<\/p>\n

The localhost problem<\/strong>
\nSo here is where we run into a problem…<\/p>\n

By default, Windows 7 and Windows 2008 R2 resolve the localhost host name to the ::1 IPv6 loopback\u00a0address, rather than the 127.0.0.1\u00a0IPv4 loopback address. Windows will resolve “localhost” to ::1, even if you have disabled IPv6 on all of the installed network addapters.<\/p>\n

This doesn’t just affect MySQL. This affects any TCP\/IP client\/server program that may use “localhost” as a connection parameter.<\/p>\n

As you can see in the image below (mouse over images, for larger image) a “Ping localhost” command, on a default w2k8 r2 install, returns the IPv6 ::1 loopback address.
\n\"\"<\/p>\n

The images below show that ping localhost returns the ::1\u00a0IPv6 address, even when IPv6 is disabled on all local network adapters.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span>\"\"<\/p>\n


\nFixing localhost IPv4 resolution<\/strong>
\nSo we’ve decideded that we don’t like this sneaky IPv6 result for localhost resolution. The software that we are running prefers that\u00a0localhost\u00a0resolve to trusty old 127.0.0.1.
\nWhat to do?<\/p>\n

We can\u00a0correct this behavior\u00a0in the Windows Hosts file, or by using the Windows registry to\u00a0modify how IPv6 works or disable IPv6 altogether. My personal preference is to use the Windows hosts file to specifically map localhost to 127.0.0.1\u00a0<\/span>and<\/em><\/strong>\u00a0<\/span>to modify the IPv4\/IPv6 resolution preference.<\/p>\n

Via Windows Hosts file<\/strong>
\nFirst, let’s take a look at the default\u00a0Windows\u00a0hosts file, at C:\\Windows\\System32\\drivers\\etc\\hosts (open with notepad)
\nIn previous versions of Windows, we find the following active entry for “localhost”
\n127.0.0.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost<\/p>\n

But in Windows 7 and Windows 2008 R2, the hosts file is effectively empty. While there are both IPv4 and IPv6 entries for “localhost”, both are disabled by being\u00a0commented out.
\n#\u00a0127.0.0.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost
\n#\u00a0::1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost<\/p>\n

The image below shows the default hosts file, on a clean install of w2k8 r2.
\n\"\"<\/p>\n

If both “localhost” entries are disabled (commented out), localhost will resolve to the ::1 IPv6 address.
\nIf both “localhost” entries are enabled (active), localhost will\u00a0<\/span>still<\/em><\/strong>\u00a0<\/span>resolve to the ::1 IPv6 address.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span>\"\"\u00a0<\/span><\/p>\n

If we\u00a0<\/span>only enable the 127.0.0.1 entry for localhost<\/em><\/strong>, then we get the proper IPv4 resolution for a ping of localhost.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span><\/p>\n

Via Windows Registry<\/strong>
\nWe can modify the behavior of Windows IPv6 from the “HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\services\\TCPIP6\\Parameters\\” registry key. The entry we are interested in is named “DisabledComponents”. But the DisabledComponents entry probably doesn’t exist on your system. So we need to create a new dword entry named “DisabledComponents”.<\/p>\n

You can now disable IPv6 support by setting the value of DisabledComponents to a hex value of ffffffff (that’s\u00a08 “f’s”). After you reboot, a ping of localhost will return 127.0.0.1, even if you don’t touch the hosts file.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span>\"\"\u00a0<\/span><\/p>\n

But instead of completely disabling IPv6 support in Windows, you can just tell Windows to prefer IPv4 over IPv6. You can do this by setting the value of DisabledComponents to a hex value of 20. After you reboot, a ping of localhost will return 127.0.0.1, even if you don’t touch the hosts file.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span>\"\"\u00a0<\/span><\/p>\n

My personal preference is a belt and suspenders approach to make sure that localhost resolves to 127.0.0.1, while trying not to break other (or future) Windows features by ripping out IPv6. I set a 127.0.0.1 IPv4 address in the hosts file\u00a0<\/span>and<\/em><\/strong>\u00a0<\/span>I set DisabledComponents to a hex value of 20, to adjust the IPv4\/IPv6 preference.
\n\"\"\u00a0<\/span>\"\"\u00a0<\/span>\"\"
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL client fails to connect to localhost on Windows, due to IPv6 A MySQL client running on Windows 2008 or Windows 7 may fail to connect to the host name of “localhost”. This is due to windows resloving the host name of localhost to the IPv6 loopback address of ::1. Windows will resolve localhost to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4519"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4519"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4519\/revisions"}],"predecessor-version":[{"id":4522,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4519\/revisions\/4522"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}