MySQL Bugs: #12332: Error assigning user privileges

Bug #12332	Error assigning user privileges
Submitted:	3 Aug 2005 5:58	Modified:	17 Aug 2005 10:52
Reporter:	Jay Ouzts	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.22a	OS:	Linux (Linux)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
The system does not allow you to grant privileges to a new user.

How to repeat:
I logged into MySQL-Administrator as root, 127.0.0.1:3306.  I selected the catalogs option and created a database called "mydatabase".

I selected the User administration option and the root user appeared in the box to the lower left.

I created a new user called new_user.   I was able to apply changes to the User Infomation tab ok.  However, the schema privileges tab was disabled.  

I noticed that the user names in the lower left spanned two "rows".  The first had "new_user@"
the second row had "localhost".  Highlighting the new_user "row" did not enable the schema privileges tab.  Highlighting the "localhost" part did.  However when I clicked the Apply Changes button, I get a Duplicate User Name error

Its as if the system thinks "localhost" is the username.  I could not add privileges to my user.

Suggested fix:
Fix should be self-evident from the description.

1) connect to server
2) catalogs -> schemata -> (right click) create schema -> (name) tst
3) user adminitration -> + new user -> (name) tstuser -> apply changes
4) select tstuser@localhost -> (tab) schema privileges -> select tst schema -> add 'create' to assigned privileges -> apply changes

and got "duplicate user name, please use another name"

press OK, press "apply changes" again  and mysql-administrator disappears and stderr contains:

(mysql-administrator-bin:13600): Gtk-WARNING **: Ignoring the separator setting
/usr/bin/mysql-administrator: line 18: 13600 Segmentation fault      $PRG-bin

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