MySQL Workbench not displaying query results
When I query a table in MySQL Workbench, no results are shown, the result section is just blank, no grid or anything. However if I export the data, it is all there. Everything worked fine until a couple days ago.
Query settings:
- Max Length = 65536
- Continue on SQL Script Error = true
- "Safe Updates = true
- Leave autocommit mode enabled = true
- Progress status update interval = 500
- Default algorithm for ALTER table = Default
- Default lock for ALTER table = Default
- Limit Rows = true
- Limit Rows Count = 1000
- Max Field Value Length to Display = 256
- Treat BINARY/VARBINARY as nonbinary character string = false
- Confirm Data Changes = True
No queries work, an example would be SELECT * FROM database.address
Answer
This is a known bug: link. Upcoming release 6.2.2 fixes this for OS X (Unfortunately, Linux version is still broken).
At least on my computer it's not dissapeared, just folded, and it's edge is almost merged with the edge of 'Action Output' block. When you move your mouse to that edge, the cursor starts looking like a dash with two arrows. Slowly move it couple of pixels higher until you catch the small 1px area where the cursor changes to a dash with a single arrow. Then catch it and pull : )
I've made a couple of photos to illustrate this.
