MySQL Bugs: #12111: mysql-administrator-1.1.0-rc-win cannot add/change users properly

Bug #12111	mysql-administrator-1.1.0-rc-win cannot add/change users properly
Submitted:	22 Jul 2005 13:52	Modified:	22 Jul 2005 20:12
Reporter:	Lee Tartak	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.0 RC	OS:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any

Description:
I have MySQL 4.1.13-nt running on Win XP Pro.  When I bing up the current
Administrator 1.1.0 rc I can add users but can not make changes to them - I get
a message about "Cant find user - refresh the list".
I then backed the Administrator to 1.0.20 and all is fine.  I think you have a problem with the 1.1.0 on Windows...
You can contact me for more info if needed.

Lee Tartak     leetartak@yahoo.com

How to repeat:
Just put Administrator 1.1.0 rc on a WinXP system, add new user make some
changes to new users Privileges (Global or Schema) save - switch to another
user.  When you go back to the user you made changes to the changes are not
there.

Hi!

I was unable to reproduce this bug using the latest version of administrator & the latest version of our 4.1 db software.

If you create table:
mysql.procs_priv with column "User" the error message does not show any more, and the user privileges are saved.

I have no idea why it needs this table, (maybe it is needed for compatibility with mySQL 5.)