Install MySQL Workbench on Ubuntu

This tutotial will show how to install MySQL Workbench on Ubuntu, to work over the version 5.6 of MySQL Server, avoiding the unmet dependencies problem.

Pre-requisites

• MySQL Server 5.6 – click here to follow to tutorial.

The Problem

On the current LTS version of Ubuntu, 14.04, if you try to directly install MySQL Workbench using apt-get as follows:

sudo apt-get install mysql-workbench

You will probably face an error as shown below:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mysql-workbench : Depends: mysql-client
E: Unable to correct problems, you have held broken packages.

Which is invalid, because since you have MySQL Server installed, the mysql-client package is already present, but named under mysql-client-5.6. This is a known bug reported by the community, but we have a couple of workarounds to make Workbench install smoothly over the version 5.6 of the server. Let’s do on of them.

The Solution

We are not going to install MySQL Workbench from apt-get, instead, we are going to download and install its binary distribution.

Download

Go to MySQL Workbench downloads page, select Ubuntu Linux as your platform and download the right version for your Ubuntu:

Installation

Once you’ve downloaded the .deb file, all you need to to is double click on it and the Ubuntu Software Center will open. If MySQL Workbench doesn’t start the installation automatically, click on Install button and wait for the process complete.

And you are done! You have the latest version of MySQL Workbench running on your MySQL Server 5.6.

Hope it helps. Cya!