Bug #60880 'Users and Privileges' user list out of sync when sorted
Submitted: 15 Apr 2011 9:44 Modified: 15 Apr 2011 10:22
Reporter: Anthony Pidden Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.33 CE OS:Windows (7 x64)
Assigned to: CPU Architecture:Any

[15 Apr 2011 9:44] Anthony Pidden 
Description:
When in the 'Users and Privileges' section, if you sort the user accounts list and attempt to modify/delete the entry it appears with the wrong user.

How to repeat:
1. In MySQL Workbench, Admin section, go to "Users and Privileges"

Userlist might look like:

'User', 'From Host'
'B', '%'
'A', '%'
'C', '%'

2. Sort users by clicking 'User' header

Userlist might look like:

'User^', 'From Host'
'A', '%'
'B', '%'
'C', '%'

3a. Click on the top of the user list ('A').
4a. The user details for 'B' come up

3b. Click the 'Remove' button with the top user on the list selected ('A')
4b. You are prompted to remove 'B'@'%'

Suggested fix:
Keep list index and data in sync (when sorting list, sort data too?)
[15 Apr 2011 10:22] Valeriy Kravchuk 
This is a duplicate of bug #59391.