MySQL Bugs: #171: Deletes user password when editting user

Bug #171	Deletes user password when editting user
Submitted:	20 Mar 2003 15:00	Modified:	27 Mar 2003 13:12
Reporter:	Harrison Fisk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.8.10 Beta	OS:	Windows (Windows 2000)
Assigned to:	Jorge del Conde	CPU Architecture:	Any

Description:
When editting a user that currently has a password, if you don't set a password, the user will no longer have a password when you are done with him.  This occurs no matter what privileges you give him.

How to repeat:
Right click on user in User Administration and go to edit user.
Click on apply in user edit screen. 
User no longer has password in database.
You can see this by doing: select user,host, password from mysql.user;
Or if you close the edit screen and reopen it is gone as well.

Suggested fix:
Make it keep the users password.

Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html