MySQL Bugs: #26693: User Accounts cannot be edited

Bug #26693	User Accounts cannot be edited
Submitted:	27 Feb 2007 19:36	Modified:	1 Mar 2007 7:47
Reporter:	Marc Hodgins (Candidate Quality Contributor)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.9	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
After clicking a user account under "User Administration" on the Users Accounts list, the status bar shows "Fetching User Data...".  Then, that status goes away, but the right pane never updates with the account information, and no error message is displayed.  The right pane remains greyed out (except for the "Add new user / apply changes / discard changes" buttons which are all active).

How to repeat:
Click "User Administration"
Click on a user in the "Users Accounts" list

Thank you for a problem report. What exact version of MySQL server are you working with? What exact user account you tried to edit? I was not able to repeat with root@localhost on 5.0.27, hence the questions.

I upgraded our server to MySQL 5.0.27 and connected from a different client machine (also Windows XP running MySQL Administrator 1.2.9).  Same problem occurs (cannot edit users, same symptoms).

Thank you for the report.

Please check if your case is same as in Bug #25515 Especcially look attention to comment "[31 Jan 10:53] Mike Lischke"

Confirmed - this appears to be the same as Bug #25515.

Running the following solved the problem:

mysqlcheck --check-upgrade --all-databases --auto-repair
and scripts\mysql_fix_privilege_tables

Clearly there is an error occurring somewhere that MySQL Administrator is not catching/displaying.  I'm not sure exactly what privilege setting had not been updated but MySQL Administrator should probably be improved to catch/display/explain what is going on here.

Thank you for the feedback.

Will close this one as duplicate of the Bug #25515