results grid not showing on mysql workbench 6.3.9 for macOS sierra

MysqlMacosWorkbench

Mysql Problem Overview


At firs it was working alright, but out of the blue it disappeared, and there is no way to bring it back. Note the gray area with the Apply and Revert buttons, where the results grid should be.

Query just executed, not the all gray area where the results grid should be

I also tried clicking on the EXPLAIN command icon, then it opens up the Explain pane, and the results grid is there (grayed out). If I click on it, it disappears.

enter image description here This is driving me nuts.

Any ideas?

Thanks

Mysql Solutions


Solution 1 - Mysql

Good News! 

Apparently this is a widespread bug on macOS High Sierra that was fixed in version 6.3.10 that was released Nov. 15th 2017.

They fixed it as described in the release notes: https://dev.mysql.com/doc/relnotes/workbench/en/wb-news-6-3-10.html

> Executing a query in MySQL Workbench on a host running macOS High > Sierra failed to load the result grid completely, which prevented > result data from appearing within the Result Grid tab. (Bug #26826418, > Bug #87714)

Download it here: https://dev.mysql.com/downloads/workbench/ (No need to uninstall the previous version, just overwrite it with the newer one)

Solution 2 - Mysql

Go there; https://stackoverflow.com/questions/39399563/mysql-workbench-6-3-mac-hangs-on-simple-queries

Still an issue for me on 6.3.9. But I'm running High Sierra (10.13 beta 9) so it might explain why .. Still, I'll probably have to install bootcamp partition.

Solution 3 - Mysql

This was happening on my instance in Ubuntu as well. Last week, there were no issues and this week, the problem arose.

Reading above, I went to Query->Explain Current Statement (CTRL+ALT+x in Ubuntu) and saw an empty explain panel with the option to view the Results Grid. I clicked on the Results Grid and MySQL Workbench crashed. I re-opened it and ran the query again and the results displayed. ymmv.

This is definitely a bug.

Solution 4 - Mysql

It happened with my MySQLWorkbench 8.0 in MacOS High Sierra. I just quit/close MySQL workbench and reopen it again. No need to uninstall and reinstall.

Solution 5 - Mysql

Same for me, since I installed High Sierra the other day it hasn't been working. If I try to run a query twice it'll freeze up. I also tried to uninstall the workbench and install an older version but it had the same problem.

EDIT: Version 6.1.7 works better. It still has some issues with large result sets but much easier to do some simple development with.

Solution 6 - Mysql

I had this problem too. Since updating to High Sierra it stopped working.

However, finally, there is a working version out there. https://bugs.mysql.com/bug.php?id=87714

EDIT: You have to remove your current Workbench version, download and install the .dmg provided in the link above and it should work. At least it worked for me - and as seen within the comments of the link -, for a lot of other people.

Solution 7 - Mysql

On macOS Sierra, the 6.1.7 version works without issues. The newer versions are very buggy

Solution 8 - Mysql

The latest version of MySQL Workbench (6.3.10) fixed that issue for me. But it still has few "stopped unexpectedly" kinda issues.

Solution 9 - Mysql

I wish i had not done the Mac update but I just uninstalled My SQL Workbench and reinstalled it with no issues. I now can run my queries and see the results grid.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionMartin OcandoView Question on Stackoverflow
Solution 1 - MysqlYogevView Answer on Stackoverflow
Solution 2 - MysqlPhilRobiView Answer on Stackoverflow
Solution 3 - MysqlJoe ColburnView Answer on Stackoverflow
Solution 4 - MysqlalltejView Answer on Stackoverflow
Solution 5 - MysqlJosh RView Answer on Stackoverflow
Solution 6 - MysqlDusty48View Answer on Stackoverflow
Solution 7 - MysqlJerome AnthonyView Answer on Stackoverflow
Solution 8 - Mysqlvijay krishnaView Answer on Stackoverflow
Solution 9 - MysqlTaylorView Answer on Stackoverflow