Monday, February 10, 2014

Installing MySQL Workbench 6.0.9 on Ubuntu 12.10

Installing MySQL Workbench from the Ubuntu Software Center of Ubuntu 12.10 (quantal) will give you a very old version 5.4.0 that's buggy - when you exit the app, it freezes. After a bit of trial and error, here's how I installed the latest (as of the date of this writing, at version 6.0.9) -
  1. Downloaded the deb file for Ubuntu 12.04 (as there was no deb package for 12.10) from the MySQL downloads page
  2. Downloaded the libctemplate0_0.97-1_i386.deb file. This package is a dependency of the MySQL Workbench 6, and isn't in Ubuntu 12.10 by default. I got this tip about the flaw from the good people of the MySQL Workbench community.
  3. Go in terminal and install the packages - 
sudo dpkg -i libctemplate0_0.97-1_i386.deb
sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1204-i386.deb

The output goes:
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 247682 files and directories currently installed.)
Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-i386.deb) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libpcrecpp0 (>= 7.7); however:
  Package libpcrecpp0 is not installed.
 mysql-workbench-community depends on libtinyxml2.6.2; however:
  Package libtinyxml2.6.2 is not installed.
 mysql-workbench-community depends on python-paramiko; however:
  Package python-paramiko is not installed.
 mysql-workbench-community depends on python-pysqlite2; however:
  Package python-pysqlite2 is not installed.
So the final step to resolve and fix the unmet dependencies was to issue this command:
sudo apt-get -f install
It will appear under your applications Development menu as MySQL Workbench. Those Workbench guys have really improved the UI, totally new look :-)