Bug #54950 When select a user under "Schema Privileges" tab, no schema shown
Submitted: 2 Jul 2010 7:42 Modified: 20 Sep 2010 1:15
Reporter: Xiaoxiang Li Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.25 OS:Linux (Ubuntu 10.4)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: account, privilege, schema

[2 Jul 2010 7:42] Xiaoxiang Li 
Description:
In "MySQL Administrator", I can see the schema's privileges assigned to the user.

But in MySQL Workbench, when select the same user under "Accounts/Schema Privileges" tab, the schemas cannot be shown in the left-top list area and there is only a scroll bar.

How to repeat:
Open MySQL Administrator, add a user named "utest" and a schema "stest", then assign all privileges of schema "stest" to user "utest".

Open MySQL Workbench, and click "Accounts" tab, then click "Schema Privileges" Tab, then select user "utest" in the "Users" list, the schema "stest" cannot be shown.
[2 Jul 2010 18:21] MySQL Verification Team 
I couldn't repeat his issue on Windows.
[6 Jul 2010 9:38] Susanne Ebrecht 
screenshot of the problem

Attachment: bug54950.png (image/png, text), 90.59 KiB.
[6 Jul 2010 9:39] Susanne Ebrecht 
Many thanks for writing a bug report.

Verified as described.

I added a screenshot of the problem.

Privileges won't show up if user has ALL.
[20 Aug 2010 1:15] Alfredo Kojima 
I can't repeat this. I ran grant all on sakila.* to root; and when selecting user root, I get an entry for the sakila schema with all the privs.

Can you paste the contents of your mysql.db table?
[20 Sep 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".