MySQL Workbench不显示查询结果

When I query a table in MySQL Workbench, no results are shown, the result section is just blank, no grid or anything. However if I export the data, it is all there. Everything worked fine until a couple days ago.

当我在MySQL Workbench中查询表时，没有显示结果，结果部分只是空的，没有网格或其他东西。但是，如果我导出数据，它就在那里。直到几天前，一切都很正常。

Query settings:

查询设置:

• Max Length = 65536
• 最大长度= 65536
• Continue on SQL Script Error = true
• 继续执行SQL脚本错误= true
• "Safe Updates = true
• “安全更新= true
• Leave autocommit mode enabled = true
• 让自动提交模式为enabled = true
• Progress status update interval = 500
• 进度状态更新间隔= 500
• Default algorithm for ALTER table = Default
• ALTER table的默认算法= Default
• Default lock for ALTER table = Default
• ALTER table的默认锁= Default
• Limit Rows = true
• 限行= true
• Limit Rows Count = 1000
• 限制行数= 1000
• Max Field Value Length to Display = 256
• 显示的最大字段值长度= 256
• Treat BINARY/VARBINARY as nonbinary character string = false
• 将二进制/VARBINARY视为非二进制字符串= false
• Confirm Data Changes = True
• 确认数据更改= True。

No queries work, an example would be SELECT * FROM database.address

查询不起作用，示例将从database.address中选择*

13 个解决方案

#1

I had the same problem after upgrading to Ubuntu 14.10. I found this link which describes the steps to be followed in order to apply the patch. It takes a while since you have to start all over again: downloading, building, installing... but it worked for me! Sorry I'm not an expert and I can't provide further details.

在升级到Ubuntu 14.10之后，我遇到了同样的问题。我找到了这个链接，它描述了应用补丁所需的步骤。你需要一段时间才能重新开始:下载、构建、安装……但它对我起作用了!对不起，我不是专家，我不能提供更多的细节。

Here are the steps described in the link above:

以下是上述连结所述的步骤:

If you want to patch and build mysql-workbench yourself, get the source from for 6.2.3. From the directory you downloaded it to, do:

如果您想自己修补并构建mysql-workbench，请从6.2.3中获取源代码。从你下载到的目录中:

wget 'http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-src.tar.gz'

wget ' http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-src.tar.gz '

tar xvf mysql-workbench-community-6.2.3-src.tar.gz && cd mysql-workbench-community-6.2.3-src

tar xvf mysql-workbench-community-6.2.3-src.tar。广州& & cd mysql-workbench-community-6.2.3-src

wget -O patch-glib.diff 'http://bugs.mysql.com/file.php?id=21874&bug_id=74147'

wget - o patch-glib。diff ' http://bugs.mysql.com/file.php?id=21874&bug_id=74147 '

patch -p0 < patch-glib.diff

补丁p0 < patch-glib.diff

sudo apt-get build-dep mysql-workbench

sudo apt-get build-dep mysql-workbench

sudo apt-get install libgdal-dev

sudo apt-get安装libgdal-dev

cd build

cd构建

cmake .. -DBUILD_CONFIG=mysql_release

cmake . .-DBUILD_CONFIG = mysql_release

make

使

sudo make install

sudo make install

Hope this can be helpful.

希望这能有所帮助。

#2

This is a known bug: link. Upcoming release 6.2.2 fixes this for OS X (Unfortunately, Linux version is still broken).

这是一个已知的错误:链接。即将发布的版本6.2.2为OS X修复了这个问题(不幸的是，Linux版本仍然有问题)。

At least on my computer it's not dissapeared, just folded, and it's edge is almost merged with the edge of 'Action Output' block. When you move your mouse to that edge, the cursor starts looking like a dash with two arrows. Slowly move it couple of pixels higher until you catch the small 1px area where the cursor changes to a dash with a single arrow. Then catch it and pull : )

至少在我的电脑上，它没有消失，只是折叠了，它的边缘几乎和“动作输出”块的边缘合并在一起。当你把鼠标移到那个边缘时，光标开始看起来像一个带有两个箭头的虚线。慢慢地将它移动到更高的几个像素点，直到你捕捉到一个小的1px区域，在那里光标变成了一个带有一个箭头的破折号。然后抓住它拉:)

I've made a couple of photos to illustrate this.

我拍了几张照片来说明这一点。

#3

The problem, as it is described, corresponds exactly to the bug MySQL Bugs: #74147: empty grid result, incompatibiliity with libglib_2.42

正如所描述的，问题正好对应于错误MySQL: #74147:空网格结果，与libglib_2.42不兼容

The good news is it's almost closed.

好消息是，它快结束了。

A patch is available since today.

一个补丁从今天开始可用。

EDIT : In Debian Jessie (testing), the problem is solved with the package mysql-workbench 6.2.3+dfsg-6 available since today.

编辑:在Debian Jessie(测试)中，问题通过软件包sql-workbench 6.2.3+dfsg-6得到解决。

#4

Update manually from mysql website

Here's a solution for Ubuntu 15.04 users running Mysql Workbench 6.2.3.

对于运行Mysql Workbench 6.2.3的Ubuntu 15.04用户，这里有一个解决方案。

I was able to resolve the issue of missing results in the Mysql workbench by just upgrading mysql-workbench to version 6.3.3 from http://dev.mysql.com/downloads/workbench/. You will need to download the one marked for Ubuntu 14.10. An install via Ubuntu software center resolved the issue. Hope this helps.

通过从http://dev.mysql.com/downloads/workbench/将sql-workbench升级到6.3.3版，我就可以解决Mysql workbench中缺少结果的问题。你需要下载Ubuntu 14.10的标记。通过Ubuntu软件中心的安装解决了这个问题。希望这个有帮助。

#5

This was still happening to me on version 6.3.9 on OSX. I downloaded 6.1.7 again to actually see the result grid again.

在OSX版本6.3.9中，这种情况仍然发生在我身上。我再次下载了6.1.7，再次看到了结果网格。

What a pain in the butt!

真讨厌!

#6

I'm using MySqlWorkbench 6.3.9 on macOS and has this problem. I removed the app and installed 6.3.10 which solves the problem.

我在macOS上使用MySqlWorkbench 6.3.9，有这个问题。我删除了应用，安装了6.3.10，解决了这个问题。

#7

If you do not want to compile it yourself you can go to:

如果你不想自己编译它，你可以去:

Applications→Ubuntu Software Center→Edit→Software Sources→Updates

there you can check hardy-proposed is ticked(for 14.10 will be utopic-proposed)

在那里你可以检查硬提议被勾选(14.10将被乌托邦提议)

Source

then simply go to terminal and type:

然后，只需进入终端，输入:

sudo apt-get install mysql-workbench

As a note, you will get other updates to, witch may not be stable!!!

注意，你将得到其他更新，女巫可能不稳定!!

#8

MySQL Workbench 6.3.4 fixes this issue. Custom builds are not needed anymore.

MySQL Workbench 6.3.4解决了这个问题。不再需要自定义构建。

http://dev.mysql.com/downloads/workbench/

http://dev.mysql.com/downloads/workbench/

#9

The result set wasn't showing for me either. I was able to make it appear by hiding the output area and running a simple select statement. Then I "show"ed the output area again and had what I was looking for -- both the result set and the output area

结果集也没有显示给我。我可以通过隐藏输出区域并运行一个简单的select语句来显示它。然后我再次“显示”输出区域，并得到了我想要的结果集和输出区域。

#10

It was really frustrating as it was still happening in the workbench version 6.3.10 (for mac) available in the mysql official site (here). I got it resolved by first collapsing the bottom panel (check the top right in the attached image (termed as collapse button)) and then pulling up the empty region from the bottom. Now if I again click on collapse button this time result grid is visible along with the action grid.

这真的很令人沮丧，因为它仍然发生在mysql官方站点(这里)的工作台版本6.3.10(用于mac)中。通过首先折叠底部面板(检查附件图像中的右上角(称为折叠按钮))，然后从底部拉起空区域，我解决了这个问题。现在，如果我再次单击“折叠”按钮，这个时间结果网格将与操作网格一起显示。

#11

I was able to solve this issue by doing the following...

我能通过做以下的事情来解决这个问题。

1. Go to the MySQL website for Workbench: https://dev.mysql.com/downloads/workbench/
2. 到MySQL网站的工作台:https://dev.mysql.com/downloads/workbench/。
3. Once there scroll to the bottom of the page and click on the tab that says "Development Releases"
4. 一旦滚动到页面底部，点击“开发发布”选项卡
5. Select your platform, download & install
6. 选择您的平台，下载和安装

You will likely want to uninstall any workbench packages already installed. GL!

您可能希望卸载已经安装的任何工作台包。GL !

#12

I had the same issue. Using MySQL 6.1 Workbench.

我有同样的问题。使用MySQL 6.1工作台。

After a while (2 mins), it just crashed. Reported bug, saved files and reopened. It works now.

过了一会儿(2分钟)，它就坏了。报告错误，保存文件并重新打开。现在工作。

I guess I would suggest if that happens again, to immediately save the open scripts, close MySQL and restart it.

我想我会建议如果再次发生这种情况，立即保存打开的脚本，关闭MySQL并重新启动它。

#13

The problem is with the TAB. From the tab's title I assume you first made a right click > "Select Rows - Limit 1000". But when you enter a different query in the opening tab, it won't show anything any more... Don't know why. Open a new tab for manual queries, then it will work.

问题出在账单上。从选项卡的标题中，我假设您首先右键单击>“选择行-限制1000”。但是当您在打开选项卡中输入一个不同的查询时，它将不再显示任何内容……不知道为什么。为手动查询打开一个新的选项卡，然后它就会工作。