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 ::1, even if IPv6 is disabled on all local network adapters.
MySQL IPv6 status
MySQL Server version 5.5.3 (March 2010) and later support IPv6 connections to localhost, using the ::1 IPv6 address. So recent MySQL 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.
解決辦法：
①卸載ipv6 （這個(gè)辦法有效但是不推薦）
②修改 hosts 文件，經(jīng)過(guò)本人測(cè)試這個(gè)在win7上有效，win10修改后無(wú)效，ping localhost 還是返回的 ::1 而不是 127.0.0.1
③升級(jí)mysql。 既來(lái)之，則安之。mysql5.53以上版本支持ipv6 在my.ini 配置文件中添加 ：
port=3306
bind-address=::
