MySQL Bugs: #25274: Application exception when add new user clicked while editing a user

Bug #25274	Application exception when add new user clicked while editing a user
Submitted:	25 Dec 2006 23:01	Modified:	23 Jan 2007 12:33
Reporter:	Geoff Hart	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.8	OS:	Windows (WinXP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	add user, edit user, user error

Description:
If while editing an existing user you click 'Add New User' and choose 'Yes' to save the changes to the current user before creating a new user, you get an application exception popup and a DOS window with another error.

If you do this, workaround is to either click 'No' or 'Abort' to the popup asking you to save changes, or to exit and restart the application after you get the exception.

Server:
MySQL 5.0.27-community-nt via TCP/IP on localhost

Client:
MySQL Client Version 5.1.11 on localhost

How to repeat:
1) Open MySQL Admin
2) Go to 'User Administration'
3) Select a user
4) Click on 'Schema Privileges'
5) Select a database
6) Add or remove any assigned permission, doesn't matter which one.
7) Click 'Add New User'
8) You will get a prompt saying 'The user xxx has been modified. Do you want to store these changes?'. Click Yes.

You now get a popup DOS window titled 'MySQL Administrator' that says '** Message: save user: error adding new user entry

You also get a popup error box titled 'MySQL Administrator Exception' saying 'Error while storing the user information. The user might have been deleted. Please refresh the user list.'

You then get returned to the same screen in MySQL Admin.

You can do other things at this point, but the application seems to be unstable and I've seen users dissappearing and application errors (crashes) at this point.

9) If you click

Suggested fix:
'Add new user' button should be disabled or should not cause an application error.

Thank you for a bug report. Verified just as described.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html