MySQL Bugs: #9427: Create new user reports an exception

Bug #9427	Create new user reports an exception
Submitted:	28 Mar 2005 7:00	Modified:	30 May 2005 11:33
Reporter:	Paul van Rossem	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.19	OS:	Windows (Windows XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
User Administration - New User command always reports exception "Error while storing the user information", although the data seems to be stored fine.

How to repeat:
Select User Administration tab; click New User button; enter new username / password and click OK.

Suggested fix:
Either don't display an exception box if there are no errors; or provide the reason why something fails, never just "cannnot ...". This doesn't help the user.

Forgot to mention; this happens with server version 5.0.3. beta.

Also noticed that changing user privileges with Administrator does not save changed privileges. Furthermore the EXECUTE privilege is missing from the list of privileges that can be changed with Administrator.

This also happens with server 4.1.11.  It seems that Administrator is unable to perform any User Administration without reporting "Error while storing user information".  The only result after this message is that a new user is created but without any privileges and privileges cannot be changed.

Have exaclty the same problem like Bill. After switching back to 4.1.10a everything works fine again.

This same issue is being discussed in #9648.
http://bugs.mysql.com/bug.php?id=9648

So far there has been a fix reported for Server 5.0.3 but none for the 4.1.11.

I agree with Roman Widmer. I also switched from 4.1.11 to 4.1.10 and everything is working correctly.

Just mentioning that this bug still exist using Server 4.1.11-nt and Administrator 1.0.20. Annoying to have to go back to the command line to admin users!!

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Please update all tables to utf8 (e.g. utf8_general_ci). The problem with EXECUTE (and other privs) in 5.x is also fixed.

I have this problem with administrator 1.1rc as well. I uninstalled it and installed 1.0.2 and it seems to work find. Mysql 4.1.13-nt, Windows XP Pro SP2.