Schema Privileges does not display in MySQL Workbench

Question

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?

Answer 1

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 Without Glitch

Answer 2

So on the Mac, and this may be different on Windows, the devs have gone minimalist with the interface in Workbench. So there are hidden controls where you have to move your mouse around until the cursor changes, only then can you see the control. Here you can see that the Schema Privileges section on the Mac doesn't show at all until you drag it up. Likely in Windows you would need to drag that right side to the right to increase the viewing area.

Here they are collapsed:

When I drag up on the hidden control they show up again:

Answer 3

I have found the solution :

In C:\Users[you]\AppData\Roaming\MySQL\Workbench\cache, delete the XXX.columns_widths file where XXX is your connection name.

J-Luc