Sunday, May 5, 2024
 Popular · Latest · Hot · Upcoming
17
rated 0 times [  17] [ 0]  / answers: 1 / hits: 44837  / 3 Years ago, tue, october 12, 2021, 5:51:16

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.


More From » 12.04

 Answers
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.


[#38139] Wednesday, October 13, 2021, 3 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
initiallartebeest

Total Points: 24
Total Questions: 118
Total Answers: 105

Location: Venezuela
Member since Thu, Jul 15, 2021
3 Years ago
;