jjmirks jjmirks - 2 years ago 76
MySQL Question

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

enter image description here

Answer Source

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:

wget 'http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-src.tar.gz'

tar xvf mysql-workbench-community-6.2.3-src.tar.gz && cd mysql-workbench-community-6.2.3-src

wget -O patch-glib.diff 'http://bugs.mysql.com/file.php?id=21874&bug_id=74147'

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


sudo make install

Hope this can be helpful.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download