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?
所以我试图在Mysql Workbench中为特定数据库创建用户和密码,但是Schema Privileges似乎并没有完全显示给我工作。有什么理由为什么?
5 个解决方案
#1
3
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.
所以在Mac上,这在Windows上可能会有所不同,开发人员在Workbench中的界面变得极简。所以有隐藏的控件,你必须移动鼠标,直到光标改变,然后才能看到控件。在这里,您可以看到Mac上的Schema Privileges部分在您向上拖动之前根本不会显示。可能在Windows中,您需要将右侧向右拖动以增加查看区域。
Here they are collapsed:
When I drag up on the hidden control they show up again:
#2
1
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.
在C:\ Users [you] \ AppData \ Roaming \ MySQL \ Workbench \ cache中,删除XXX.columns_widths文件,其中XXX是您的连接名称。
J-Luc
#3
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.
这是一个错误(故障),已经报告给MySql团队。当它被修复时,我遇到了同样的问题;请通过“恢复”窗口模式使用它。
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.
定义用户时,当Workbench窗口处于全屏模式(这是启动时的默认模式)时,“Schema Privileges”选项卡不起作用。嵌入式窗口中仅显示“Schema”列,并且缺少“revoke all privileges”,“delete entry”和“add entry”按钮。
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.
单击“恢复”窗口按钮时问题消失,并且当Workbench窗口返回到全屏时不会再次出现。
Glitch 
Without Glitch 
小故障没有毛刺
#4
0
I had this same problem after my Windows 10 crashed due to a power outage during a Windows update. Win10 basically installed a fresh copy of itself but kept my user directory, which included my original %AppData% settings from mysql. I basically blew away the entire contents of C:\Users{my user name}\AppData\Roaming\MySQL\Workbench ... after which things started working properly again.
由于Windows更新期间断电导致我的Windows 10崩溃后,我遇到了同样的问题。 Win10基本上安装了自己的新副本但保留了我的用户目录,其中包括我原来的mysql%AppData%设置。我基本上吹走了C:\ Users {我的用户名} \ AppData \ Roaming \ MySQL \ Workbench ...的全部内容,然后事情再次开始正常工作。
#5
0
Clearing AppData didn't work for me. It was bugging me on Windows 10 Workbench 6.3.x.
清除AppData对我不起作用。它在Windows 10 Workbench 6.3.x上让我烦恼。
Solution was to uninstall it and re-install 6.2.5, by clicking "Previous GA version" from download page. It was back to the old, black Home screen, my connections were still there from 6.3.x and the UI glitch is gone.
解决方案是从下载页面单击“上一个GA版本”卸载它并重新安装6.2.5。它回到了旧的黑色主屏幕,我的连接仍然存在于6.3.x,UI故障消失了。
#1
3
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.
所以在Mac上,这在Windows上可能会有所不同,开发人员在Workbench中的界面变得极简。所以有隐藏的控件,你必须移动鼠标,直到光标改变,然后才能看到控件。在这里,您可以看到Mac上的Schema Privileges部分在您向上拖动之前根本不会显示。可能在Windows中,您需要将右侧向右拖动以增加查看区域。
Here they are collapsed:
When I drag up on the hidden control they show up again:
#2
1
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.
在C:\ Users [you] \ AppData \ Roaming \ MySQL \ Workbench \ cache中,删除XXX.columns_widths文件,其中XXX是您的连接名称。
J-Luc
#3
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.
这是一个错误(故障),已经报告给MySql团队。当它被修复时,我遇到了同样的问题;请通过“恢复”窗口模式使用它。
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.
定义用户时,当Workbench窗口处于全屏模式(这是启动时的默认模式)时,“Schema Privileges”选项卡不起作用。嵌入式窗口中仅显示“Schema”列,并且缺少“revoke all privileges”,“delete entry”和“add entry”按钮。
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.
单击“恢复”窗口按钮时问题消失,并且当Workbench窗口返回到全屏时不会再次出现。
Glitch Without Glitch
小故障没有毛刺
#4
0
I had this same problem after my Windows 10 crashed due to a power outage during a Windows update. Win10 basically installed a fresh copy of itself but kept my user directory, which included my original %AppData% settings from mysql. I basically blew away the entire contents of C:\Users{my user name}\AppData\Roaming\MySQL\Workbench ... after which things started working properly again.
由于Windows更新期间断电导致我的Windows 10崩溃后,我遇到了同样的问题。 Win10基本上安装了自己的新副本但保留了我的用户目录,其中包括我原来的mysql%AppData%设置。我基本上吹走了C:\ Users {我的用户名} \ AppData \ Roaming \ MySQL \ Workbench ...的全部内容,然后事情再次开始正常工作。
#5
0
Clearing AppData didn't work for me. It was bugging me on Windows 10 Workbench 6.3.x.
清除AppData对我不起作用。它在Windows 10 Workbench 6.3.x上让我烦恼。
Solution was to uninstall it and re-install 6.2.5, by clicking "Previous GA version" from download page. It was back to the old, black Home screen, my connections were still there from 6.3.x and the UI glitch is gone.
解决方案是从下载页面单击“上一个GA版本”卸载它并重新安装6.2.5。它回到了旧的黑色主屏幕,我的连接仍然存在于6.3.x,UI故障消失了。