MySQL Connector ODBC / phpmyadmin / IPv6

[Julien Gros]

Hi,

we have some databases on some remote VPS server, we grant access users via phpmyadmin and users access databases through MySQL Connector ODBC. This works perfectly when we connect to the internet with an IPv4, here is how I proceed usually (in the message below, I modified the actual values for safety reasons):

In MySQL Connector / ODBC, I write in TCP/IP Server : 135.252.124.187 (this is the server’s IP), Port: 3306

In phpMyAdmin, to grant access to a user, I write for example 154.179.21.165 (the IP of our internet box).

However we have recently ordered new boxes from our internet service provider and these boxes have an IPv6 type IP...

IPv6 of the box is 2001:741:8kg2:1460:% (I use a wildcard at the end because it changes, works fine when I do this with Ipv4)

IPv6 of the server is 2001:47f0:463:7znc:135.252.124.187.

I tried several things to no avail: 2001:47f0:463:7znc:135.252.124.187 in TCP/IP server, also tried leaving 135.252.124.187, in phpmyadmin I tried 2001:741:8kg2:1460:% and also 2001:741:8kg2:1460:%%%%:%%%%:%%%%:%%%%

The provider of the server said our server is configured for IPv6 and they don’t see why it shouldn’t work.

Any idea of what I am doing wrong? I read somewhere IPv6 address might have to be written between brackets... ?

Thanks!