Bug #9989 Confusing user tree display
Submitted: 19 Apr 2005 2:45 Modified: 27 Apr 2005 15:50
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S4 (Feature request)
Version:ALL OS:Linux (Linux/Debian)
Assigned to: CPU Architecture:Any

[19 Apr 2005 2:45] [ name withheld ]
Description:
This is forward from http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=293415

When admining users via mysql-admin it is unclear when there exists a
user root@%. The other default root accounts show root@localhost
clearly, and root@mymachine.com. These users have their own entries
after expanding root.
However for root@% the details are on the unexpanded root node. The only
visual clue you get that the account exists is that the 'Schema Priv'
and 'Resource Limits' tabs are not greyed out.
It would be better if root@% had it's own entry.

For example, when selecting 'User Administration', in the 'User
Accounts' window pane on the bottom left, instead of this:
+-root
|  |
|  +--root@localhost
|  +--root@mymachine.com
|

It would be better to have this:
+-root
|  |
|  +--root@%
|  +--root@localhost
|  +--root@mymachine.com
|

This is almost a minor bug, but my opinion is that the security
ramifications of misunderstanding the accounts for root are serious for
administrators.

How to repeat:
.
[27 Apr 2005 15:50] Alfredo Kojima
Hi Adam,

I agree this is a undesirable (mis)feature. I have changed the tree so that the % account will be shown separately, as a subitem.