What does MySQL “::1” hostname refer to?

::1 is the IPv6 address for localhost.

The details (incl.those relevant to the Windows case) are at http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html.