MySQL Bugs: #9371: Assigned priv's not displayed

Bug #9371	Assigned priv's not displayed - 'def' database reference
Submitted:	23 Mar 2005 22:58	Modified:	18 Apr 2005 23:41
Reporter:	John Healy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.6-beta	OS:	MacOS (Mac OS X 10.3.5)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Test local LAN configuration: MySQL 4.0.20 running on an iMac G4 under Mac OS X 10.3.8; MySQL Administrator running on PowerMac G4 under Mac OS X 10.3.5, MySQL Client 4.1.8.

Existing database and table priv's assigned to users in existing databases are not reflected in MySQL Administrator -- none are shown as assigned. All existing databases are shown under a "def" heading. Attempts to assign priv's result in user-specific priv table entries in mysql tables on server which reference a "def" database which does not in fact exist!

How to repeat:
Remove bogus "def" entries in mysql db table using phpMyAdmin. Check exisitng priv's using phpMyAdmin. Relaunch MySQL Administrator and check what priv's show for users. In MySQL Administrator pick a user and assign any priv such as Select or Insert for an end-user database.

Suggested fix:
Could not find any similar postings.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html