MySQL Bugs: #14020: Can not add new user

Bug #14020	Can not add new user
Submitted:	14 Oct 2005 2:12	Modified:	18 Oct 2005 9:48
Reporter:	Andrew Gregory	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.3	OS:	Windows (Win2k3Server, XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
error when trying to add new user from localhost or remote access..

Windows Critical Error :

MySQL Administration Exception

'Error while storing the user information. The user may have been deleted. Please refres the user list.'

Basically can't add any new users with the latest MySQL admin. using MySQL 5.0.13-rc-nt- via TCP/IP

How to repeat:
Add a new user and apply changes

Suggested fix:
not really sure.. have not seen this problem before. Is totall clean install on server and client..

Refreshing user list removes last added user from console, presumably there is no user added...

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

You will find a similar discussion here in the Forums of a third-party MySQL client:
http://www.webyog.com/forums/index.php?showtopic=1724 .

One user experienced that MySQL 5.0.13 via the Config Wizard configured itself to start in 'strict mode' (system variable @@sql_mode set to 'STRICT_ALL_TABLES').

The user table of MySQL 5.0.13 have three columns *ssl_cipher*,'x509_issuer' and 'x509_subject' that are BLOBs and thus can't have a default.  That is a problem with that client, since it assumes defaults for columns not specified!  Maybe the same here ?  Can't these columns be TEXTs and have a default?  I think they should be if they are character data!

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