Bug #85983 The tab page "Schema Privileges" UI in Workbench is broken
Submitted: 18 Apr 2017 13:02 Modified: 18 Apr 2017 13:20
Reporter: Juan F. Ruiz Fernandez Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:6.3.9 OS:Windows (10.0.15063)
Assigned to: CPU Architecture:Any

[18 Apr 2017 13:02] Juan F. Ruiz Fernandez
Description:
When i select the Management option "Users and Privileges" in left pane and then select any user in "Users Accounts" and click on "Schema Privileges" tab the content below is cut off and I can not add schemas in which to give privileges to the selected user.

How to repeat:
- Open a connection to the local server.
- 
- Click in Navigator Pane: "MANAGEMENT - Users and Privileges"
- In the main tab to the right with title "Administration - Users and privileges" select any user account in grid "User Accounts". For example: root 
- Select the 4th tab to the right with title "Schema Privileges".

Suggested fix:
I know that certain SQL order can do the functionality:

Login as root in mysql console or connect as root in Workbench and type in this:

GRANT SELECT, INSERT, DELETE ON database TO username@'localhost' ;

Where SELECT, INSERT, ... are the grants, database is the name of the schema where these grants apply and username@'localhost' is the name of the user (or other variations).

But i want to do in UI ... ;-)
[18 Apr 2017 13:07] Juan F. Ruiz Fernandez
Capture from the UI bug

Attachment: mysql-bug-data-85983.png (image/png, text), 118.19 KiB.

[18 Apr 2017 13:19] MySQL Verification Team
Hello Juan F. Ruiz Fernandez,

Thank you for the bug report. 
This is most likely duplicate/related with bug https://bugs.mysql.com/bug.php?id=85079 and https://bugs.mysql.com/bug.php?id=85182

Thanks,
Umesh
[18 Apr 2017 13:20] Juan F. Ruiz Fernandez
Sorry to all people. I've seen this is a duplicated bug!.