MySQL Bugs: #6185: table privileges not recognized because host value missing, server

Bug #6185	table privileges not recognized because host value missing, server > 4.1.4
Submitted:	20 Oct 2004 20:51	Modified:	3 Nov 2004 15:15
Reporter:	Tod Carrier	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.13	OS:	Windows (Win 2000)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
It appears that I am adding privileges at the database level in the Administrator.  When I check those privileges, they appear to NOT be granted.  I looked at the table and see this row, with no host data value.

                 Host: 
                   Db: datatrak
                 User: nbku52o
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
    Create_tmp_table_priv: Y
     Lock_tables_priv: Y

 

How to repeat:
Use v4.1.5 or v4.1.6 MySQL server.

Add a login.

Grant the login some privileges in a database, not test or mysql, through Administrator.

Refresh.  See if the privileges are still there.

Suggested fix:
?

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

This is ths same bug as http://bugs.mysql.com/bug.php?id=5957
The fix will be in the MySQL Administrator 1.0.14