Bug #53050 Connection fails using Workbench (fine with sqlyog)
Submitted: 22 Apr 2010 9:18 Modified: 22 Apr 2010 21:50
Reporter: dan matthews Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.2.19 OS:Microsoft Windows (7)
Assigned to: CPU Architecture:Any
Tags: authentication, Connection, password, Security

[22 Apr 2010 9:18] dan matthews
I appreciate this sounds fairly ridiculous but I am unable to connect to my local database using the Workbench.

I am using the default connection settings (IP, port etc) and user (root). The password works fine when I connect using a different tool (Sqlyog).

I have checked and re-checked for a stupid mistake on my part but am unable to get past this.

How to repeat:
Load workbench.

Create new connection using all default, specify password and hit Test Connection, dialog states:

Access denied for user root@localhost (using password: YES)
[22 Apr 2010 9:18] dan matthews
updated os info
[22 Apr 2010 9:24] dan matthews
Right, I have found the cause, the password was very short (2 chars, I know, not exactly secure but it was a dev temp database!) and it appears WorkBench doesnt allow authentication with a 2 char password. I have changed to a long password and it now connects ok...
[22 Apr 2010 16:13] Johannes Taxacher
i tried successfully with accounts having passwords of 1 and 2 char length ... 
dan, did you copy or type the passwd into the password dialog? could you try to reset to the 2-char passwd and see if the problem comes back?
thanks in advance
[22 Apr 2010 19:06] dan matthews
I was typing in the 2 char password (and had to re0type it in SqlYog to change the password so I know I was typing the correct one. I cannot replicate on subsequent 1 or 2 char passwords so think this should be closed but i am stumped as to how the bug originally manifested itself, i am pretty confident it wasnt just me typing the password incorrectly!
[22 Apr 2010 21:50] MySQL Verification Team
Thank you for the bug report.