Mysql grant limited by IPv6 subnet
::, as I understand IPv6 indicates as many chunks of all zero as are needed to fill out the full length.  The question comes as to whether MySQL treats % as a single chunk and treat fdd7:03d7:6247::% as fdd7:03d7:6247:0000:0000:0000:0000:% or interpret it some other way.  (Sorry, I don't know the answer.)

A second problem is that /56 splits the middle of some chunk.  I don't know if that can be represented with %.

Anyway, here's my best guess:

'fdd7:03d7:6247:00%'


This confirms PacoHope's contention that leading zeros in each segment are optional:

SELECT HEX(INET6_ATON('1111:698:2222::'));
         --&gt;           11110698222200000000000000000000