Bug #25868 There is no method to Refresh User List in User Administration
Submitted: 26 Jan 2007 12:09 Modified: 27 Apr 2007 17:00
Reporter: Stephen Gornick Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.10, 1.2.8 OS:Linux (Linux)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: account, Administration, administrator, linux, mysql administrator, refresh, user, user account, user list

[26 Jan 2007 12:09] Stephen Gornick
Description:
Under User Administration option, the list of User Accounts appears to only be read once, and is never refreshed. 

If I add or delete a user in an external app, such as MySQL Query Browser, that change will not be reflected in the User Accounts list.

How to repeat:
Launch MySQL Administrator, and login as root.
Click on User Administration.

Leav MySQL Administrator, then Launch MySQL client
  $ mysql -u root -p 
  $ create user TestUser;
  $ exit;

Switch the task back to MySQL Administrator.

The list of User Accounts will not show TestUser, nor is there any way to refresh the list.

Suggested fix:
The Catalogs option accomodates a similar problem for the list of schemas by allowing right-click within the schemata panel which then displays a "Refresh Schemata" selection. 

Add similar functionality for the User Accounts list for the User Administration option.

This is the way it works in MySQL Administrator for Windows, and apparently for Mac as well now, as was implemented for bug 23787:
 http://bugs.mysql.com/bug.php?id=23787
[26 Jan 2007 12:10] Stephen Gornick
edit typo in title
[28 Feb 2007 13:34] Sveta Smirnova
Windows and Mac version have this functionality: severity was changed.
[2 Mar 2007 19:18] Valeriy Kravchuk
Please, try to repeat with a newer version, 1.2.10 (from GUI Tools 5.0-r10), and inform about the results.
[5 Mar 2007 20:34] Stephen Gornick
Behavior persists in MySQL Administrator v1.2.10 (Linux).
[20 Mar 2007 23:06] Sveta Smirnova
Thank you for the report.

Verified as described.
[27 Apr 2007 17:00] Alfredo Kojima
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html