results grid not showing on mysql workbench 6.3.9 for macOS sierra

D

9

59

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

Dolorous answered 30/8, 2017 at 18:26 Comment(2)

I am not able to see results grid in Mac OS High Sierra... – Rondo 26/9, 2017 at 5:58

Same thing for me since High Sierra, i really shouldnt updated. So many Bugs. I updated everything, mysql, workbench. Nothing helped – Rugged 12/10, 2017 at 15:25

R

55

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)

Remount answered 21/11, 2017 at 6:1 Comment(5)

Thanks man, i was struggling what happened to the output screen? why it is not coming? and then today i found your solution – Lallage 2/3, 2018 at 5:45

Also available using Homebrew: brew cask install mysqlworkbench – Odilia 18/7, 2018 at 5:46

Just an FYI, it's still an issue but is intermittent in 8.0.12 (MySQL WB). I have to restart MWB everytime this happens. – Marrilee 28/8, 2018 at 17:46

I've got it with MySQLWorkbench version 8.0 on Mojave. – Unsheathe 17/10, 2018 at 16:57

I got it OS Monterey 12.6. Updated Workbench and now have to update OS... ughhhh... Now lets update EVERYTHING.... lol (face-palm) – Tunnell 16/8, 2023 at 1:2

I

8

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.

Interinsurance answered 3/9, 2017 at 20:28 Comment(3)

I'm on High Sierra Beta 9 as well. But it was happening on Sierra 10.2.6 before installing the Beta, so I don't think is the OS. – Dolorous 4/9, 2017 at 21:55

On High Sierra (10.13 (17A365)) there are plenty of new bugs, hanging queries, not showing results panel, not opening more than one connection.... impossible to use. Already did all suggestions found on Google and nothing – Amii 26/9, 2017 at 22:9

I've just upgrade to 6.3.10 and now it works perfectly. – Shampoo 4/1, 2018 at 10:32

M

7

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.

Maniac answered 13/9, 2017 at 0:58 Comment(1)

I had no crash but this finally got me to display the results grid! Nice one. – Greig 8/8, 2018 at 14:50

S

5

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.

Sensitive answered 25/8, 2018 at 3:35 Comment(0)

B

4

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.

Barrens answered 29/9, 2017 at 15:33 Comment(0)

B

4

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.

Bedew answered 14/10, 2017 at 21:48 Comment(3)

Please include the answer directly in your SO post. Links may be useful but they do not constitute a proper answer. – Lueluebke 14/10, 2017 at 22:11

Did anyone else's Mac prompt for every password in the keychain again when the .dmg file included in the above link was installed? I got prompted for github, email, database instances, icloud password. Is this file to be trusted? – Adamson 18/10, 2017 at 9:4

Hey, I haven't had this issue. However, this seems weird. – Bedew 18/10, 2017 at 19:44

N

1

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

Nidus answered 19/10, 2017 at 1:52 Comment(0)

P

1

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

Prevent answered 20/11, 2017 at 8:28 Comment(1)

Same for me. I had the issue with 6.3.9 on High Sierra 10.13.6 but updating to 6.3.10 fixed the problem. – Lumper 25/7, 2018 at 13:53

S

0

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.

Softshoe answered 18/11, 2017 at 21:38 Comment(0)

Recommended topics

Hot tags