Installing MySQL Workbench on Ubuntu 12.04 LTS
1. Download the latest MySQL Workbench
2. Download a .deb file for libzip1 as it is not available in the 12.04 repos.
- 32 bit version - https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb
- 64 bit version - https://launchpad.net/ubuntu/+source/libzip/0.9.3-1/+build/1728114/+files/libzip1_0.9.3-1_amd64.deb
3. Double click on .deb file (for libzip1) to install using software centre
4. Download libmysqlclient16 package as it was removed from the 12.04 repos and install the same (see step 3)
- 32 bit version - http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb
- 64 bit version - http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb
5. Install following packages using Terminal:
- sudo apt-get install libzip1 python-paramiko python-pysqlite2 libctemplate0 libgtkmm-2.4-1c2a libmysqlclient16
6. Then cd to the directory where you have downloaded the mysql workbench deb file and run:
- sudo dpkg -i mysql-workbench-gpl-5.2.38-1ubu1104-i386.deb
7. If it works, then great else run -> sudo apt-get upgrade... This will display all the dependencies and install the same for you. My terminal output below as it did not work the first time for me...
+++++++++++++++++++++++++++++++++++++++++++++++++++
~$ sudo apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
mysql-workbench-gpl : Depends: libmysqlclient18 (>= 5.5.13-1) but it is not installed
Depends: libzip2 (>= 0.10) but it is not installed
Depends: mysql-client
E: Unmet dependencies. Try using -f.
~$ sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libzip2 mysql-client
mysql-client-5.5 mysql-client-core-5.5
Suggested packages:
libterm-readkey-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libzip2 mysql-client
mysql-client-5.5 mysql-client-core-5.5
0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 12.2 MB of archives.
After this operation, 44.0 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
P.S. - Credit: http://setupguides.blogspot.in/2012/04/install-mysql-workbench-on-ubuntu-1204.html