Bug #49024 MySQL can't run in ipv6 network
Submitted: 24 Nov 2009 6:52 Modified: 8 Jan 2014 11:51
Reporter: Kai Liu Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version:5.1.41 OS:Windows (win2003 x86)
Assigned to: CPU Architecture:Any
Tags: ipv6

[24 Nov 2009 6:52] Kai Liu
I am install mysql 5.1.41 in ipv6 ipv4 network windows server 2003 hosting.

I try use mysql GUI tool and all php codes can't connect to mysql with use localhost,::1 and ipv6 public ip address.

only it have to use connect to mysql.

How i do mysql support ipv6 connect ?

How to repeat:
all software and codes can not connect to mysql ipv6 address.  

Suggested fix:
MySQL should support ipv6 connect.
[24 Nov 2009 7:15] Valeriy Kravchuk
Please, check if mysql command line client from 5.1.41 can connect. It works for me on Linux and Mac OS X.

If mysql command line client can connect then this can be a problem of older tools that use old libmysqlclient library.
[24 Nov 2009 8:31] Kai Liu
I have try use MySQL GUI Tools 5.0-r17,  Navicat 8.2.17,phpmyadmin and php5.3.1 all lastest version all can't connect to ::1 or public ipv6 ip address.

"Could not resolve hostname ::1"

now I have try install MYSQL5.4.3-beta, GUI client can connect "localhost". but php codes can't and all GUI client not may connect to ::1 or public ipv6 address. I have close all firwall also.  

I have been saw the http://bugs.php.net/bug.php?id=50172 report. 

I think GUI client can not connect mysql with ipv6 address. then it should not only is php bug. mysql should has some issue also.
[24 Nov 2009 8:45] Valeriy Kravchuk
Please, answer my question. Try to connect with mysql command line client from 5.1.41 or 5.4.3 to server using IPV6 address. I need to know if it works or not on Windows.
[24 Nov 2009 9:23] Kai Liu
your mean is use conmmand in windows dos ?

what's mysql command want to try ? I will do.
[24 Nov 2009 10:00] Kai Liu
ok. I have try use mysql conmmand connect with ipv6 address.

mysql v5.1.41 result:


mysql v5.4.3 result:
[24 Nov 2009 10:46] Valeriy Kravchuk
OK, and what is the output of the following commands in cmd.exe:

ping 9600.xiaoyu.net
ipconfig /all
[24 Nov 2009 11:40] Kai Liu

[24 Nov 2009 14:15] Valeriy Kravchuk
Looks like I've used MySQL 5.5.x when IPV6 support worked for me on Mac and Linux. 

We have similar feature requests since long time ago, and complete implementation had to be included into MySQL 6.0 (see http://forge.mysql.com/worklog/task.php?id=798 for the details). I do not know, yet, in what formal milestone release (MR) and when IPV6 will be officially supported, but I expect 5.5.x.
[24 Nov 2009 15:16] Kai Liu
where are downlaod mysql5.5 and 6.0?
[24 Nov 2009 15:34] Valeriy Kravchuk
They are not released yet officially (and 6.0 was removed some time ago from our site), but you can find source code trees at:

[25 Nov 2009 8:03] Kai Liu
ok. thanks. I will waiting new mysql support ipv6. 
what is your email address. I will save it.
[8 Jan 2014 11:51] Ståle Deraas
Closing as IPv6 support was added to 5.5.6.
[8 Jan 2014 11:56] Ståle Deraas
Posted by developer:
This was implemented in 5.5.6