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: Bugs System CPU Architecture:Any

[20 Oct 2004 20:51] Tod Carrier
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:
?
[3 Nov 2004 15:15] Victor Vagin
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