How to make use of IPv6 link-local addresses in the MySQL client & server (Doc ID 1454405.1)

Last updated on SEPTEMBER 21, 2014

Applies to:

MySQL Server - Version 5.5 and later
Linux x86
Linux x86-64
Apple Mac OS X (Intel) (32-bit)
Apple Mac OS X (PowerPC)

Goal

IPv6 supports a style of addressing called "Link Local".  These addresses are specific to the ethernet network they are on and cannot be routed globally.

Of particular note, the same subnet (fe80::/16) is used to create an address for all interfaces assigned to a machine.  As a result, standard routing decisions are unable to indicate where packets should originate from.  

To solve this problem, most operating systems require you to bind any socket using a link-local address to a specific network interface, which can be specified by using a special IP address suffix.

This has been verified to work on the latest versions of the operating systems specific in the application section of this article.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms