Bug #65107 Conflict with TCP/IP v6: error 10061 on login via MySQL Workbench
Submitted: 26 Apr 2012 3:00 Modified: 1 Nov 2012 22:48
Reporter: Henry Schroeder Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.39 OS:Windows (Microsoft Windows XP Home Edition Service Pack 3 (build 2600))
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Apr 2012 3:00] Henry Schroeder 
Description:
When TCP/ IP4 and TCP/IP6 are active in a WinXP32 or WinXP64 system, MySQL 5.5.23 returns error 10061 when we try to login to the server using MySQL Workbench 5.2.39  revision 8757, although it's still possible to interact with the server via ODBC/ Access 2003. Once the TCP/IP Version 6 driver is uninstalled, everything gets back to normal again.

How to repeat:
In a system running WinXP32 or WinXP64 with TCP/IP4 enabled, try installing the driver for TCP/IP6 and enabling it. Following, start the MySQL server version 5.5.23 and try to login to localhost:3306 via workbench 5.2.39. At this point, the system will return error 10061, as if the MySQL server was disabled OR the password was wrong. Using Access and ODBC driver you can still login to the server and run queries and get any data from the database, showing that the server is up and running perfectly well. Uninstall the TCP/IP6 driver, and the system resumes the normal state.
[26 Apr 2012 5:48] Valeriy Kravchuk 
Please, connect somehow and send the results of:

select user, host from mysql.user;

statement. I think this problem may be related to the user name that you use to connect from Workbench and/or to the IP-address (IPV4 or IPV6 one) that localhost is resolved to.
[27 May 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[6 Sep 2012 12:06] Itzik Roytman 
I've stuck with same bug on windows xp mysql server 5.5 after installing tcp/ip 6 I'm not able to connect with old gui tools, and still connect via php script.

investigating this issue I'd tryied to issue telnet 127.0.0.1 3306 command that failed. telnet localhost 3306 still succeed. removing tcp ip 6 solved this issue.
[1 Oct 2012 22:48] MySQL Verification Team 
Please try version 5.2.44. Thanks.
[2 Nov 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".