Bug #2849 MySQL Administrator doesn't show % host under a user
Submitted: 17 Feb 2004 15:54 Modified: 18 Feb 2004 8:10
Reporter: Harrison Fisk Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.1a OS:Windows (Windows)
Assigned to: Michael G. Zinner CPU Architecture:Any

[17 Feb 2004 15:54] Harrison Fisk
Description:
When listing off the users, MySQL Administrator doesn't list off the % host for a user.  

This makes it impossible to remove the % host from a user.

How to repeat:
Add a user in MySQL as user@'%'
Look at the users accounts listing and notice the % doesn't exist.
Try to find someway to change the % to be only localhost.
Add localhost and it shows up, but still no way to remove %.

Suggested fix:
List the % host for the user as well as specific hostnames.
[18 Feb 2004 8:10] Michael G. Zinner
This is actually not a but but a feature. We try to hide the % from the users, to simplify the user administration.

A user in the MySQL Administrator is the same user, regardless if he connects from % or localhost or 192.168.1.14.

If he needs to have different privileges when connection from a different host, you add the host.

Sure, this limits some of the features, but it makes it easier to handle. And you can still use the command line client if you need this extra functionality.