MySQL Bugs: #69934: Cannot edit default schema privileges for test and test\

Bug #69934	Cannot edit default schema privileges for test and test\_%
Submitted:	6 Aug 2013 7:09	Modified:	5 Nov 2013 1:07
Reporter:	Mario Beck	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.0.5	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	privileges, test database

Description:
On MySQL servers there are two default schema based privileges that cannot be edited via workbench.
This creates confusion if I revoke all privileges for a user and apply changes. That user can still fully access test and test\_% databases. There is no place in Workbench where I can see these privileges.

How to repeat:
mysql> SELECT host,db,user,select_priv FROM db;
+------+---------+------+-------------+
| host | db      | user | select_priv |
+------+---------+------+-------------+
| %    | test    |      | Y           |
| %    | test\_% |      | Y           |
+------+---------+------+-------------+
2 rows in set (0,00 sec)

Try to find and modify these settings in workbench.
Workbench only shows real users but omits rows where user=""

Suggested fix:
At least display a dummy user entry that indicates that there are wildcard entries.
Unfortunately schema privileges support wildcards so these entries are not directly linked to the user table.
The perfect implementation would offer editing schema privileges independent of the user list.

Please check:

http://dev.mysql.com/doc/refman/5.6/en/default-privileges.html

"In addition, the mysql.db table contains rows that permit all accounts to access the test database and other databases with names that start with test_. This is true even for accounts...."

What would you like to do with these? Would allowing to view and delete them be enough or do you have a use case for changing and creating these too?

Thank you for the bug report

Posted by developer:
 
FIXED.
Verified in:
Windows 7x64
Ubuntu 12.04x64
MySQl Server 5.6
WB 6.0.8.11345
Privileges displayed and dropped successfully.

Fixed as of MySQL Workbench 6.0.7, and here's the changelog entry:

Privileges that do not have a corresponding user entry will now be
displayed in MySQL Workbench, so that they can be properly deleted by the
user. This includes the "test" database.

Thank you for the bug report.