64 Bit Jungle

So, the latest Linux Alpha version has been released for MySQL Workbench 5.1, with a bunch of features added, and lots of bugs fixed. Once again, 32 Bit users can install from a precompiled deb, which can be downloaded from one of the available MySQL Workbench 5.1.5 mirrors. Once downloaded, it can be installed with dpkg:

sudo dpkg -i mysql-workbench-5.1.5-1_i386.deb

64 Bit users still have to compile from source, but it’s progressed significantly since v5.1.3, and now the ctemplate-library is linked statically within the 5.1.5 code, so there’s no need to download, compile and install ctemplate any more. There are still several prerequisites that need installing before compiling 5.1.5, but they can all be obtained via apt:

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

The rest of the compile and install instructions are the same as my MySQL Workbench 5.1.3 Alpha Linux tutorial, but for the sake of brevity are repeated here. First, grab the source from one of the MySQL Workbench 5.1.5 mirrors - as usual, I downloaded it to my now incredibly cluttered Desktop - then I made a couple of directories in my Home folder to house the source code (~/mysqlwb-src) and the compiled application (~/mysql-workbench), and finally compiled and installed:

cd ~/Desktop
mkdir ~/mysqlwb-src
mkdir ~/mysql-workbench
mv mysql-workbench-5.1.5-alpha.tar.gz ~/mysqlwb-src
cd ~/mysqlwb-src
tar -zxvf mysql-workbench-5.1.5-alpha.tar.gz
cd mysql-workbench-5.1.5-alpha
./autogen.sh
make install DESTDIR=/home/<username>/mysql-workbench

The DESTDIR option tells make to install it into the ~/mysql-workbench directory created earlier, which for now is better than a system wide installation. To run it, navigate to the install bin dir and run the executable:

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

Remember it’s Alpha, so not recommended for use in a Production environment, or on a Production DB!

written by Hodge \\ tags: MySQL, workbench

Ok, so this is a few weeks after it’s been released, but I’ve not had much of a chance to catch up on these things! Anyway, following my post on MySQL Workbench 5.1.3 Alpha, here’s an update on installing the latest version - 5.1.4 Alpha. 32 Bit users can install from the repositories, by first adding the following to /etc/apt/sources.list so, open up a Terminal, and run the following:

gksu gedit /etc/apt/sources.list

Once the Text editor is open, add the following lines to the end of the file:

deb ftp://ftp.mysql.com/pub/mysql/download/gui-tools/ubuntu/ binary/
deb-src ftp://ftp.mysql.com/pub/mysql/download/gui-tools/ubuntu/ source/

Save the file, and close the Editor. From the terminal, run:

sudo apt-get update
sudo apt-get install mysql-workbench

That’s it. 64 Bit users still have to compile and install from the source tarball - the latest version of which can be downloaded from ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.4alpha.tar.gz, but the instructions are the same as in my previous post “MySQL Workbench 5.1.3 Linux Alpha - Testing on 32 bit and 64 bit Ubuntu“.

This version has loads of bug fixes and some new features implemented, but it’s still not recommended to use on a Production DB!

written by Hodge \\ tags: database, MySQL, workbench