0
How can I connect to mysql using Ipv6?
I am using a Debian Linux Virtual Machine (VM) and am trying to connect via prompt
When I try like this:
mysql --host=9999:9999:9999:1:xxx9:x999:2b23:ccab --user=admin --password
This error occurs:
ERROR 2003 (HY000): Can’t connect to Mysql server on 9999:9999:9999:1:xxx9:x999:2b23:ccab' (101 "Network is unreachable")
Note: The cited Ipv6 is only one example, but is in the same structure as my original.
Edited
After enabling Ipv6 in my VM, according to one of the comments, started to give this error:
ERROR 2003 (HY000): Can’t connect to Mysql server on '9999:9999:9999:1:xxx9:x999:2b23:ccab' (113 "No route to host")
Ipv6 service is also required on your computer.
– Michael Hampton
@Michaelhampton I enabled Ipv6 as you indicated and now another problem occurs, see the issue of my question. What more need to do?
– Matheus Ribeiro
Port 3306 is open on the firewall?
– Michael Hampton
@Michaelhampton Yes, door 3306 is open
– Matheus Ribeiro
Which is the way out of:
traceroute6 9999:9999:9999:1:xxx9:x999:2b23:ccab?– Michael Hampton
That’s all it keeps showing
sendto: Invalid argument
 1 traceroute: wrote 9999:9999:9999:1:xxx9:x999:2b23:ccab 24 chars, ret=-1
 *sendto: Invalid argument
traceroute: wrote 9999:9999:9999:1:xxx9:x999:2b23:ccab 24 chars, ret=-1– Matheus Ribeiro
Does the actual Ipv6 address start with
fe80::? Those are local link addresses and require a scope ID, for example.fe80::b487:58ad:8d3f:d7b%enp2s1.– Michael Hampton
Real ip starts with 2001:4860.... It’s an Ipv6 generated by Cloud SQL from Google Cloud Platform. I’m trying to access the Cloud SQL database from the Computer Engine.
– Matheus Ribeiro