Support for IPv6 in MySQL includes these capabilities:
MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host:
mysql -h ::1
To use this capability, two things must be true:
Your system must be configured to support IPv6. See Section 184.108.40.206, “Verifying System Support for IPv6”.
As of MySQL 5.6.6, the default MySQL server configuration
permits IPv6 connections in addition to IPv4 connections.
Before 5.6.6, the default is to permit only IPv4
connections. To change the default configuration, start
the server with an appropriate
--bind-address option. See
Section 5.1.4, “Server System Variables”.
MySQL account names permit IPv6 addresses to enable DBAs to
specify privileges for clients that connect to the server over
IPv6. See Section 6.2.3, “Specifying Account Names”. IPv6 addresses can
be specified in account names in statements such as
REVOKE. For example:
CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret';mysql>
GRANT SELECT ON mydb.* TO 'bill'@'::1';
IPv6 functions enable conversion between string and internal
format IPv6 address formats, and checking whether values
represent valid IPv6 addresses. For example,
INET6_NTOA() are similar to
INET_NTOA(), but handle IPv6
addresses in addition to IPv4 addresses. See
Section 12.18, “Miscellaneous Functions”.
The following sections describe how to set up MySQL so that clients can connect to the server over IPv6.
Copyright © 1997, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices