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:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.22a OS:Linux (Linux)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[3 Aug 2005 5:58] Jay Ouzts
The system does not allow you to grant privileges to a new user.

How to repeat:
I logged into MySQL-Administrator as root,  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.
[3 Aug 2005 13:29] Aleksey Kishkin
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
[17 Aug 2005 10:52] Vladimir Kolesnikov
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