Where can I find the MySQL Workbench dependencies?

Installing the .deb 32-bit, I have this warning:

Dependendy is not satisfiable: libmysqlclient16 (>=5.1.21-1)

Have tried to apt-get install libmysqlclient16:

E: Package 'libmysqlclient16' has no installation candidate

And this apt-get install libmysqlcliente18 installed correctly but when trying to install MySQL Workbench again, I have the same error.

EDIT

I have tried this but the result:

sudo gdebi mysql-workbench-gpl-5.2.40-1ubu1104-i386.deb 
Reading package lists... Done
Building dependency tree        
Reading state information... Done
Building data structures... Done 
Building data structures... Done 
This package is uninstallable
Dependency is not satisfiable: libmysqlclient16 (>= 5.1.21-1)

EDIT Making the installation apt-get install mysql-workbench worked but installed an older version of it.


Solution 1:

I used Daniel Mota's documentation a bit, but needed to modify some of his commands:

You can get the necessary mysql workbench deb here

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.

Mysql Work Bench Installation Completed.

In the comments Peter K. let me know this was not working in Ubuntu 16.04. So here is the easiest way to get it working in Xenial. I still followed the link above to get the latest mysql workbench deb file (MySQL Workbench 6.3.7 at the time of this correction)

This is how I pulled it down and placed it in /tmp :

wget -P /tmp http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.3.7-1ubu1604-amd64.deb

I used the chmod command in order to make the .deb file executable, then used dpkg -i to install it (use sudo if you are not switched to root alread):

chmod +x /tmp/mysql-workbench-community-6.3.7-1ubu1604-amd64.deb
sudo dpkg -i mysql-workbench-community-6.3.7-1ubu1604-amd64.deb

You will see the failed dependencies:

dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libtinyxml2.6.2v5; however:
  Package libtinyxml2.6.2v5 is not installed.
 mysql-workbench-community depends on libzip4 (>= 0.10); however:
  Package libzip4 is not installed.

To remedy this, use apt to help resolve (fix) the dependencies:

sudo apt-get -f install

This will show you the missing dependencies allowing for you to install them without any further steps.

The following additional packages will be installed:
  libtinyxml2.6.2v5 libzip4
The following NEW packages will be installed:
  libtinyxml2.6.2v5 libzip4

You should now be able to launch mysql-workbench in Xenial.

Solution 2:

This installed mysql-workbench 5.2 with all dependencies as of 20120531.

sudo apt-get install mysql-workbench

Solution 3:

I found the package "mysql-workbench" in the default repository.

apt-cache search mysql-workbench

no additional config or hack needed, works for me

Solution 4:

source: setupguides.blogspot.nl/

Install MySQL Workbench on Ubuntu 12.04

Currently there is no pre-built .deb file or repo available to install MySQL Workbench on Ubuntu 12.04. One will probably appear soon after official release of 12.04 but at the moment it is still in beta so there are a few extra steps to get it working.

NOTE: Once Ubuntu 12.04 moves out of beta there will probably be a better way of doing this so please check the official MySQL Workbench download page and the official 12.04 repos before attempting this.

First of all you will need to download the latest MySQL Workbench from here.

Next you must 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 for other architectures go here

After downloading just open them with the software centre and click install.

*NEW: The libmysqlclient16 package was removed from the 12.04 repos so you will need to download the old deb files for it:

32 bit version - launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb

64 bit version - launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb

Next open a terminal and install the following packages:

sudo apt-get install libzip1 python-paramiko python-pysqlite2 libctemplate0 libgtkmm-2.4-1c2a libmysqlclient16

Then cd to the directory where you downloaded the deb file and run:

sudo dpkg -i mysql-workbench-gpl-5.2.38-1ubu1104-i386.deb

And that should be it, enjoy!

Instructions loosely based on those found here: blog.csdn.net/kevin6216/article/details/7420421