MySQL Workbench 5.1 Beta Released for Linux

Posted by on Mar 22, 2009 in Databases, Linux, Ubuntu2 comments

mysql workbench ossI’ve had a play with a few of the previous Alpha releases, and so far so good. Yesterday, MySQL Workbench 5.1 Beta was released, so I decided to download it and give it a go. There is currently no official 64 Bit binary installer available, so we still need to compile from the source. This has, however, become a much less complicated task since the initial Alpha releases!

32 Bit users

32 Bit users need only download the precompiled deb from one of the MySQL Mirrors, and once downloaded, the deb can be installed by opening a Terminal and running the following:

sudo dpkg -i mysql-workbench-oss-5.1.9-1_i386.deb

64 Bit users

To compile MySQL Workbench from source, a bunch of dependencies need to be installed, which can be done easily by running the following in a Terminal:

sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libgl1-mesa-glx mesa-common-dev libmysqlclient15-dev uuid-dev liblua5.1-dev libpixman-1-dev libpcre3-dev libgnome2-dev libgtk2.0-dev libpango1.0-dev libcairo2-dev python-dev

The source package can be downloaded once again from one of the MySQL Mirrors. As usual, I downloaded to my Desktop, and ran the following to compile and install:

mkdir mysqlwb-src mysql-workbench
mv Desktop/mysql-workbench-oss-5.1.9.tar.gz mysqlwb-src
cd mysqlwb-src
tar -zxvf mysql-workbench-oss-5.1.9.tar.gz
cd mysql-workbench-oss-5.1.9
make install DESTDIR=/home/<username>/mysql-workbench

I’m using the DESTDIR option, since with Workbench being in Beta, I don’t really want it installing system wide.

Unless you’re lucky enough to have a machine with ridiculous specs, this will take a while – so go make a brew, coffee, smoke a cigarette, or [instert short term recreational activity here], and come back in a few.

No, really – it takes a long time…

Once installed (took a long time, eh?), running it is easy – simply navigate to the installation directory and run the executable from the Terminal:

cd ~/mysql-workbench/usr/local/bin