MySQL Bugs: #28573: Can not View or Edit User Privs in MySQL Administrator

Bug #28573	Can not View or Edit User Privs in MySQL Administrator
Submitted:	21 May 2007 19:46	Modified:	22 Jun 2007 7:18
Reporter:	Colin Kendall	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Windows (SP2)
Assigned to:		CPU Architecture:	Any
Tags:	edit user, Edit Users, mysql administrator, User Privs

Description:
When attempting to select a user to update their privs in the User Administration area of then Administrator tool, the User Information Tab in the right pane is grayed out displays "No User Selected". 

When Right Clicking in the Users pane, Clone user, Delete user, Add Host from which the user can connect and Remove Host from which the user can connect options are also grayed out.

I have read similar bug reports that describe an error message popping up, but that is not case here.  Just trying to select a user to edit their privs.  Creating users and setting privs at creation time works fine.

How to repeat:
Windows XP SP2
MySQL 5.0
MySQL GUI Tools installed including MySQL Administrator 1.2.12

Create user, then attempt to edit user by selecting them.

Thank you for a problem report. Please, specify the exact MySQL server version you had used (5.0.x). Are you connecting as root user with MySQL Administrator? I can not repeat the behaviour described while connected as root to 5.0.37, hence the requests.

Could you please try to add a host for one user (right click over the user
and select add host from..) then verify again. I was able to view and edit
in this way. Thanks in advance.

When I right click a user, the option to add a host is not enabled.  When I right-click a user, the 'Clone user', 'Delete user', 'Add host from which user can connect' and 'Remove host from which user can connect' options are ALL disabled.  I can only select 'Add new user',  'Show hosts in user list' and 'Refresh user list'.

Thanks you for your help.

Same Problem Here
MySQL V5.0.41 on RedHat V4
MySQL Administrator on WinXP SP2

Can create user, then can not edit user grants. The choices on left click are all grayed out.

Tried MySQL V5.0.27 on same server with same results.

However, 
MySQL V5.0.21 on RedHat V3
MySQL Administrator on WinXP SP2

Can create user, then can edit user grants. The choices on left click are NOT grayed out.

I also noticed that when I select a user in the lower left pane after about 1 second or so, what seems to be a stop button or wait button appears in the bottom left corner of the application. You can see a screen shot here:

(http://www.scribd.com/doc/101030/MySQLAdmin)

Thanks again for you help.
Colin

Thank you for the feedback.

But this is by design: MySQL identifies users by both name and host. So you should click host to clone or edit user.

First of all, in order to get to the Clone user option, it is a RIGHT-click, secondly, "Edit" and "Host" are not even options in the RIGHT-click menu, and thirdly, as I have posted posted earlier, the Clone option is disabled when  RIGHT-clicking on a user.  Adding hosts for users is OPTIONAL, not required.

Please do NOT change the status of my bug report until I have a resolution to the problem.

Thank you.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Please look screenshot at the MySQL Administrator manual http://dev.mysql.com/doc/administrator/en/mysql-administrator-user-administration-user-acc... to take point how user interface should look.

Its too bad Sveta was unhelpful because I had this same problem, however it appears not to be a bug, but an upgrade issue (at least for me and the other person I got fix from). 

mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables (I believe this one did the trick) 

Credit where credit is due: http://forums.mysql.com/read.php?34,96793,147183#msg-147183

I am running into the exact same problem.  I'm running Win7 (x64) and had a fresh install of mySQL 5.5.10 (x64) and GUI tools 5.0 r17 (x32).  I can't edit or create new users from the GUI.  Opens are grayed out, the same as mentioned above.

If anyone is still running into this, like I just did using Windows Vista, MySQL Administrator 1.2.12 and trying to connect to a remote server running MySQL 5.5.24-0ubuntu0.12.04.1, a solution that worked for me was to user MySQL Workbench (my version: 5.2.44) instead of the MySQL Administrator.