Schema Privileges does not display in MySQL Workbench

mysql user-interface workbench
user6153087 picture user6153087 · Apr 2, 2017 · Viewed 7.9k times · Source

So I was trying to create a user and password for a particular database in Mysql Workbench, but the Schema Privileges does not seem to display completely for me to work on. Any reasons as to why?

Schema Privileges

Answer

vipul kumawat picture vipul kumawat · Mar 25, 2018

It is a bug (glitch), and already reported to MySql team. I had the same problem, by the time it get fixed; Please use it by "restore down" window mode.

When defining a user the "Schema Privileges" tab is non-functional when the Workbench window is in fullscreen mode (which is the default mode on start-up). Only the "Schema" column is shown in the embedded window and the "revoke all privileges", "delete entry", and "add entry" buttons are missing.

The problem goes away when the "restore down" window button is clicked and does NOT re-appear when the Workbench window is returned to fullscreen.

Glitch with glitch Without Glitch without glitch

Related questions

How to view table contents in Mysql Workbench GUI?

How can I view table contents in Mysql workbench GUI? I mean, not from command line.

Read More
Database design: 3 types of users, separate or one table?

I have 3 types of users: Admins Suppliers Employees Each user type will have different user interface and access different types of data. Their only similarity is they are using one web application but they access totally different things. Is it …

Read More
Is there a GUI tool for MYSQL with query builder feature?

I am using MySQL Workbench. I can't deny that it's a very good tool. Unfortunately it doesn't have a query builder feature. So I wonder if there is another one that has a query builder feature?

Read More