MySQL Bugs: #65739: Can't Set Blank Password

Bug #65739	Can't Set Blank Password
Submitted:	26 Jun 2012 22:29	Modified:	13 Nov 2012 3:59
Reporter:	Tom Wardrop	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.40	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
In MySQL Workbench, using the Server Administration interface to manage privileges, it's not possible to set a users password to an empty string. It doesn't error out of anything, it just fails to update the password to an empty string.

How to repeat:
1) Log into the server management interface of a SQL server (I was using 5.5 to a remote host).
2) Go to "Users and Privileges" and select a user account from the list that you wish to change the password for.
3) Try setting a blank password. The "Apply" button remains grayed out unless you trigger a change event on the form. If you change the password field, then change it back to nothing and click "Apply", you'll notice the password is not set to empty. It remains set to as it was previously.

Suggested fix:
Either allow empty passwords to be set via the password text fields that are there, or if that has undesirable consequences, provide a checkbox for setting the password to empty.

Thank you for the problem report. Verified on Windows XP.

I just got bitten by this. Took me a while to figure out why I kept getting access denied errors. Now I know why! Is there any way to 'vote' or make a request to indicate popularity of this bug like there is in other bug tracking systems?

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

 The "Server Access Management" interface would not allow a 
 password to be set as an empty string.

Thank you for the bug report.