Friday, 20 July 2012

Install MySql Workbench in ubuntu 12.04

First run the following:
sudo dpkg -i mysql-workbench-gpl-5.2.40-1ubu1104-i386.deb
As you know this will fail about the dependencies. Then wget and install the following:
wget https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb
wget http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb
Next install:
sudo dpkg -i libzip1_0.9.3-1_i386.deb
sudo dpkg -i libmysqlclient16_5.1.58-1ubuntu5_i386.deb
  • If you're using 64bit, you'll want this instead:
    wget https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_amd64.deb
    sudo dpkg -i libzip1_0.9.3-1_amd64.deb
    
    wget http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
    sudo dpkg -i libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
    
Then run the following:
sudo apt-get -f install python-paramiko libzip2 libmysqlclient18 mysql-client mysql-common python-pysqlite2 libdbi-perl libdbd-mysql-perl libplrpc-perl libnet-daemon-perl mysql-client
This too will fail, and ask you to re-run, just re-run it again:
sudo apt-get -f install
When that completes it should be installed for you, leave a comment if you run into any snags and I'll try and see if I can help you further.
Launch it once from either your terminal mysql-workbench or Unity Dash, once it's in the launcher, right click on it and select "Lock to Launcher".
I have not used this program to know whether or not it is stable after installation, YMMV.