results grid not showing on mysql workbench 6.3.9 for macOS sierra
MysqlMacosWorkbenchMysql 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.
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.
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.