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
解决方案
I had the same problem after upgrading to Ubuntu 14.10. I found this link which describes the steps to be followed in order to apply the patch. It takes a while since you have to start all over again: downloading, building, installing... but it worked for me! Sorry I'm not an expert and I can't provide further details.
Here are the steps described in the link above:
If you want to patch and build mysql-workbench yourself, get the source from for 6.2.3. From the directory you downloaded it to, do:
tar xvf mysql-workbench-community-6.2.3-src.tar.gz && cd mysql-workbench-community-6.2.3-src
patch -p0 < patch-glib.diff
sudo apt-get build-dep mysql-workbench
sudo apt-get install libgdal-dev
cd build
cmake .. -DBUILD_CONFIG=mysql_release
make
sudo make install
Hope this can be helpful.