MySQL Bugs: #9055: Cannot edit users thru the tool

Bug #9055	Cannot edit users thru the tool
Submitted:	8 Mar 2005 20:08	Modified:	11 Mar 2005 23:01
Reporter:	Niels Meersschaert	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.6-beta	OS:	MacOS (OS X 10.3.8)
Assigned to:		CPU Architecture:	Any

Description:
Clicking on any user in the Accounts section of MySQL Administrator results in a pop-up window that says Error retrieving user information.  Attempts to click the disclosure triangle to see the hosts also results in the pop up.

To test if this was caused by older user IDs, I created a new user ID.  I was able to modify data on the new user, however, once I quit MySQL Administrator & re-connected to that database, I had the same pop-up even on the newly created user.  

Looking at the mysql database schema, it appears a new table called user_info was created.  Adding new entries to reflect the other user ids also didn't fix the situation.

This was specifically tested on a machine running OS X 10.3.8 Server with the factory installed MySQL server.

I've attempted logging in as the root user in case this was a permission issue, but no luck with that approach either.

How to repeat:
Open MySQL Administrator.  Log into server running on OS X.  Switch to the accounts tab.  Click on any user name.

Suggested fix:
No known workaround.

Hi.

I was unable to repeat this bug report.  Can you please send me step by step instructions that reproduce this behaviour ?

Thanks

I've tried this now from another client & still get the pop up error: Error retrieving user information.  

Here are the details of the information screen if it assists in isolating the issue:
Connected to MySQL Instance
User: root
Host: localhost
Socket: /tmp/mysql.sock

Server Information
MySQL Version: MySQL 4.0.18 via TCP/IP
Network Host: localhost
IP: 127.0.0.1

Client Information
Version: MySQL Client Version 4.1.8
Operating System: Darwin 7.8.0
Hardware: 2x Power Macintosh (PowerPC G4) 1000.0 MHz, 1.5 GB RAM

I was able to rectify the issue by running mysql_fix_privilege_tables.