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

[23 Mar 2005 22:58] John Healy
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.
[18 Apr 2005 23:41] Alfredo Kojima
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.