Configuring MySQL Server to Permit IPv6 Connections.

MySQL server listens on a single network socket for TCP/IP connections.
This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces, also in IPv6.

If the address is 0.0.0.0, the server accepts TCP/IP connections on all server host IPv4 interfaces.

If the address is ::, the server accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces.
Use this address to permit both IPv4 and IPv6 connections on all server interfaces.

If the address is an IPv4-mapped address, the server accepts TCP/IP connections for that address, in either IPv4 or IPv6 format.
For example, if the server is bound to ::ffff:127.0.0.1, clients can connect using –host=127.0.0.1 or –host=::ffff:127.0.0.1.

If the address is a ‘standard’ IPv4 or IPv6 address (such as 127.0.0.1 or ::1), the server accepts TCP/IP connections only for that IPv4 or IPv6 address.

It is necessary to be sure that the mysql.user grant table contains an account with administrative privileges assigned to the right IP address.


Comments are closed.