MySQL Workbench Schemas 面板不起作用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26547926/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Workbench Schemas Panel not working
提问by Bob
I have a trouble with my mysql workbench 6.0 (i work on ubuntu) and when i choose a server instance, instead of the "schemas panel" it's wrote "No object selected". In the "SQL panel" (main panel), the query "show databases;" works but i have no list of the databases in the "schemas panel".
我的 mysql 工作台 6.0（我在 ubuntu 上工作）有问题，当我选择服务器实例时，它写的是“没有选择对象”而不是“模式面板”。在“SQL 面板”（主面板）中，查询“show databases;” 有效，但我在“架构面板”中没有数据库列表。
I have this problem with all my intances and when there is a lot of databases and tables, it's annoying !
我所有的实例都有这个问题，当有很多数据库和表时，这很烦人！
Have you any ideas about this problem ? Thanks,
你对这个问题有什么想法吗？谢谢，
回答by Martin Klosi
Have you tried dragging the window boarder just above the "Object Info" button?
您是否尝试将窗口边框拖动到“对象信息”按钮上方？
回答by honglin zhang
I have the same issue on Mac. I tried uninstall MySQL, Workbench, but doesn't work.
我在 Mac 上有同样的问题。我尝试卸载 MySQL、Workbench，但不起作用。
the solution for me is:
我的解决方案是：
quit workbench
in Terminal:
退出工作台
在终端：
cd ~/Library/Application\ Support/MySQL/Workbench/
rm wb_state.xml
rm wb_options.xml
cd ~/Library/Application\ Support/MySQL/Workbench/
rm wb_state.xml
rm wb_options.xml
which reset workbench setting and configurations
重置工作台设置和配置
- start workbench again. everything back to normal
- 再次启动工作台。一切恢复正常
If you are using Windows or Linux. do the same for below file path
如果您使用的是 Windows 或 Linux。对以下文件路径执行相同操作
Windows %AppData%\MySQL\Workbench\ Linux ~/.mysql/workbench/
Windows %AppData%\MySQL\Workbench\ Linux ~/.mysql/workbench/
回答by Wasif Kirmani
I was facing the same issue in MacOS and deleting the caches worked for me. But, the path in MacOS is not the same
我在 MacOS 中遇到了同样的问题，删除缓存对我有用。但是，MacOS 中的路径不一样
Windows %AppData%\MySQL\Workbench\
OS X ~/Library/Application\ Support/MySQL/Workbench/
Linux ~/.mysql/workbench/
I deleted the wb_options.xml and wb_state.xml files and restarted Workbench and all was back to normal.
我删除了 wb_options.xml 和 wb_state.xml 文件并重新启动了 Workbench，一切都恢复了正常。
回答by Mhluzi Bhaka
Had the same issue and deleting the cache files worked for me.
有同样的问题，删除缓存文件对我有用。
I am on windows but it seems the path for Linux is "~username/.mysql/workbench/"
我在 Windows 上，但似乎 Linux 的路径是“~username/.mysql/workbench/”
The windows path is "%AppData%\MySQL\Workbench\"
windows路径为“%AppData%\MySQL\Workbench\”
I deleted the wb_options.xml and wb_state.xml files and restarted Workbench and all was back to normal.
我删除了 wb_options.xml 和 wb_state.xml 文件并重新启动了 Workbench，一切都恢复了正常。
More details on the settings and log files here: https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html
有关设置和日志文件的更多详细信息，请访问：https: //dev.mysql.com/doc/workbench/en/wb-configuring-files.html
回答by Andrius Bentkus
Just delete(or move if you want to save them) the config files, on unix it is in ~/.mysql/workbench, don't know where workbench saves it under other platforms.
把配置文件删除（或者移动，如果你想保存它们），在unix上它在~/.mysql/workbench中，不知道其他平台下workbench保存在哪里。
回答by Flavio Ariano
Close Workbench. Remove from Windows Task Manager.
关闭工作台。从 Windows 任务管理器中删除。
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 是您的连接名称。
Open Workbench again, select Schema Priveleges and change window Workbench size and after maximize window.
再次打开 Workbench，选择 Schema Priveleges 并更改窗口 Workbench 大小和最大化窗口后。
回答by cengineer
It may be a small problem about the UI itself. I said maybebecause in my case it was just about not having a good UX.
可能是UI本身的一个小问题。我说maybe是因为就我而言，这只是没有良好的用户体验。
If you can see only 2 tabs on the left sidebar namely Object Infoand Sessionat the very top of the sidebar, then you may be able to drag the top of the sidebar to the bottom. And ta-da! Your Management schemes appears! They were just sleeping there while I was searching on the web.
如果您只能在左侧边栏Object Info和边栏Session顶部看到 2 个选项卡，那么您可以将边栏顶部拖到底部。还有达达！您的管理方案出现了！当我在网上搜索时，他们只是在那里睡觉。
回答by shruti bidada
OS X
~/Library/Application\ Support/MySQL/Workbench/
操作系统
~/Library/Application\ Support/MySQL/Workbench/
I deleted the wb_options.xmland wb_state.xmlfiles and restarted Workbench and all was back to normal.
我删除了wb_options.xml和wb_state.xml文件并重新启动了 Workbench，一切都恢复了正常。
回答by Viju
just move your cursor in sidebar panel (Management,Instance,Performance) whichever is last shown in the panel, once your cursor is change (available for dragging Panel) drag panel below.
只需在侧边栏面板（管理，实例，性能）中移动您的光标，以面板中最后显示的为准，一旦您的光标发生变化（可用于拖动面板）拖动面板下方。
回答by karl
delete :
删除 ：
<value type="int" key="DbSqlEditor:SecondarySidebarHidden">0</value>
<value type="int" key="DbSqlEditor:SecondarySidebarWidth">218</value>
