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.
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.
This is driving me nuts.
Any ideas?
Thanks
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)
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.
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.
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.