Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

results grid not showing on mysql workbench 6.3.9 for macOS sierra

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

like image 927
Martin Ocando Avatar asked Aug 30 '17 18:08

Martin Ocando


People also ask

How do I enable the result grid in MySQL Workbench?

Place the text cursor on a query and use the "EXPLAIN command" for the statement under the cursor. That will open the Visual Explain window. In that window you can find Results Grid. Click on that Results Grid.

How can I see the result grid in MySQL?

Right-click a result grid subtab to open the context menu, which appears in the figure that follows. The result grid context menu includes: Rename Tab: Customize the name (title) of this tab. Pin Tab: Pin the results tab to the result grid.

What version of MySQL Workbench is compatible with High Sierra?

Install MySQL Workbench15. It is the latest one that is compatible with High Sierra. You can't physically install newer versions. When it's downloaded double click the installation file and then click and drag the MySQL Workbench App into your Applications folder to install.

Does MySQL Workbench work with Mac?

MySQL Workbench provides platform support for the latest version of macOS only (see supported platforms). The previous version continues to be supported for a transition period of six months after each new version of macOS is released.


2 Answers

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)

like image 110
Yogev Avatar answered Sep 16 '22 17:09

Yogev


Go there; 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.

like image 42
PhilRobi Avatar answered Sep 20 '22 17:09

PhilRobi