How to install MySQL Workbench on Elementary OS (Freya)

Hello there, I am, trying and testing some software development posts written in english, to see how many visitors engage.

So here’s the thing. A few days ago, I decided to work on my current projects in Elementary OS Freya, and in the many tools I use on regular basis, MySQL Workbench is one of them that is very important and useful to design and manage mysql databases. But, for some reason, MySQL Workbench has some known issue running on Elementary OS, and, it is that when you run a query, the result area just gets blank, nothing shows up, not even the grid or error message.

So, the first reaction is: “what the fuck?”.

This bug is present on the default MySQL Workbench build that comes with the Freya repositories,  this is a build a little outdated and the bug has is relationated with some UI libraries that also are outdated. So the solution is simple: patch and compile a newer version of the program.

In your command line, execute the following commands:

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
make
sudo make install

After that, just run MySQL Workbench from the command line in the folder you just installed it or create a launcher in your apps folder.

Hope this helps.

Later.