MySQL Bugs: #49024: MySQL can't run in ipv6 network

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:	None
Category:	MySQL Server: Connection Handling	Severity:	S4 (Feature request)
Version:	5.1.41	OS:	Windows (win2003 x86)
Assigned to:		CPU Architecture:	Any
Tags:	ipv6

Description:
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 127.0.0.1 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.

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.

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.

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.

your mean is use conmmand in windows dos ？

what's mysql command want to try ? I will do.

ok. I have try use mysql conmmand connect with ipv6 address.
Result:

mysql v5.1.41 result:

http://china.org.ru/tz/mysql5.1.41.jpg

mysql v5.4.3 result:
http://china.org.ru/tz/mysql5.4.3.jpg

OK, and what is the output of the following commands in cmd.exe:

ping 9600.xiaoyu.net
ipconfig /all

ok.done.

http://china.org.ru/tz/ipv6.jpg
http://china.org.ru/tz/ipv6-1.jpg
http://china.org.ru/tz/ipv6-2.jpg
http://china.org.ru/tz/ipv6-3.jpg

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.

where are downlaod mysql5.5 and 6.0?

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:

https://code.launchpad.net/~mysql/mysql-server/mysql-next-mr
https://code.launchpad.net/~mysql/mysql-server/mysql-6.0-codebase

ok. thanks. I will waiting new mysql support ipv6. 
 
what is your email address. I will save it.

Closing as IPv6 support was added to 5.5.6.

Posted by developer:
 
This was implemented in 5.5.6