'MySQL Workbench not displaying query results

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.

Query settings:

Max Length = 65536
Continue on SQL Script Error = true
"Safe Updates = true
Leave autocommit mode enabled = true
Progress status update interval = 500
Default algorithm for ALTER table = Default
Default lock for ALTER table = Default
Limit Rows = true
Limit Rows Count = 1000
Max Field Value Length to Display = 256
Treat BINARY/VARBINARY as nonbinary character string = false
Confirm Data Changes = True

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

enter image description here

mysql mysql-workbench

Solution 1:^[1]

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

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 : )

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

Step 1 Step 2 Step 3

Solution 2:^[2]

New to MySql myself and found this is happening on Windows as well. Goto Query > Explain Current Statement > click on the Results Grid icon on the far right of the Visual Explain window that shows by default. You may have to toggle through the up down arrow icons to see it.

Solution 3:^[3]

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.

Solution 4:^[4]

The problem, as it is described, corresponds exactly to the bug MySQL Bugs: #74147: empty grid result, incompatibiliity with 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.

Solution 5:^[5]

Update manually from mysql website

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

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.

Solution 6:^[6]

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.

What a pain in the butt!

Solution 7:^[7]

The easiest fix for me to see the Result Grid again was to click on Explain Command

[ enter image description here

After that Execution Plan is going to be shown and on the right side you can click on Result Grid

Solution 8:^[8]

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.

Solution 9:^[9]

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) demo image

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!!!

Solution 10:^[10]

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

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

Solution 11:^[11]

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

Solution 12:^[12]

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

Go to the MySQL website for Workbench: https://dev.mysql.com/downloads/workbench/
Once there scroll to the bottom of the page and click on the tab that says "Development Releases"
Select your platform, download & install

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

Solution 13:^[13]

I had the same issue. Using MySQL 6.1 Workbench.

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

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

Solution 14:^[14]

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.

Solution 15:^[15]

I have updated macOS to 10.13.4 and it works.

Solution 16:^[16]

I searched for almost an hour, tried everything, restarted Workbench, upgraded Workbench, used the "explain query" trick, but nothing worked.

The explanation for the result grid not showing anymore was actually very stupid: there was a INSERT INTO mytable few lines above the SELECT query. I share it anyway because it might help some other people.

Solution 17:^[17]

I had this problem too. I think it is a problem "screen size" related. Some Workbench versions present this problem, accordingly the numerous other answers.

However, I'd solved this by simply lowering the monitor resolution and the Result Grid has back to be draggable with the mouse pointer (very like the Thaumant answer already indicated).

I've taken these photos to illustrate what I'm saying.

At 1440x900 the Result Grid draggable selector are not being showed...

Now, in 800x600 resolution (with 125% of scale) the Result Grid has back to be draggable !

Works too with greater resolutions along with bit of scaling*

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Thaumant
Solution 2	rob23
Solution 3	Satyam Naolekar
Solution 4
Solution 5	Jossef Harush Kadouri
Solution 6	zmonteca
Solution 7	Black
Solution 8	oOEric
Solution 9	Mihai
Solution 10	to_masz
Solution 11	karmarro
Solution 12	daveomcd
Solution 13	Panthersfball234
Solution 14	Gabor
Solution 15	latovic
Solution 16	RotS
Solution 17

'MySQL Workbench not displaying query results

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Solution 4:[4]

Solution 5:[5]

Update manually from mysql website

Solution 6:[6]

Solution 7:[7]

Solution 8:[8]

Solution 9:[9]

Solution 10:[10]

Solution 11:[11]

Solution 12:[12]

Solution 13:[13]

Solution 14:[14]

Solution 15:[15]

Solution 16:[16]

Solution 17:[17]