Cannot install mysql-workbench with mysql-server 5.6 or mariadb

[Rocko]

mysql-workbench depends on mysql-client, which is currently at 5.5, so it won't install with mysql-server 5.6 installed:

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

apt-get install mysql-client:
...
The following packages have unmet dependencies:
 mysql-client : Depends: mysql-client-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: mysql-workbench (not installed)
ProcVersionSignature: Ubuntu 3.13.0-14.34-generic 3.13.5
Uname: Linux 3.13.0-14-generic x86_64
ApportVersion: 2.13.2-0ubuntu5
Architecture: amd64
Date: Tue Mar 4 07:38:08 2014
InstallationDate: Installed on 2014-02-08 (23 days ago)
InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Alpha amd64 (20140207)
ProcEnviron:
 LANGUAGE=en_AU:en
 TERM=xterm
 PATH=(custom, no user)
 LANG=en_AU.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-workbench
UpgradeStatus: No upgrade log present (probably fresh install)

SRU DOCUMENTATION

[IMPACT]
mysql-workbench as the default GUI cannot be installed on systems where the maintainer either opted to use mysql 5.6 or mariadb.

[TEST CASE]
Install mariadb-client and try to add mysql-workbench. Aptitude will not allow this and you will be forced to revert to mysql-client version 5.5 or abort the installation of mysql-workbench.

[REGRESSION POTENTIAL]
There is some potential for regression here since we are dropping a depends to a recommends.

Debian upstream did this exact change in version 6.2.3+dfsg-7 of the package so it seems unlikely this would be improper. Nonetheless, there should be some testing done to verify there is no obvious breakage by running the GUI.

I tried to do some code inspection but grepping for mysql (the command that would be called) was too generic to be useful.

[Hans Joachim Desserud (hjd)]

Thanks for taking your time to repor this issue and help making Ubuntu better.

I was able to reproduce this issue by first installing mysql-server-5.6 and then attempting to install mysql-workbench.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Alberto Salvia Novella (es20490446e)]

It prevents the package (or a dependent one) from functioning correctly at all.

[Michal Zubkowicz (michalzubkowicz)]

Same problem with mariadb installed:
The following packages have unmet dependencies:
 mysql-workbench : Depends: mysql-client

[Michal Zubkowicz (michalzubkowicz)]

This problem is really important. Now i have workaround by removing mysql-workbench from package list (don't try this at home ;))) . There is any way i can help ?

[Ryan Hansen (ketiko)]

Same issue here.

[Sushant kumar (sushantp606)]

I have installed MariaDb and then tried to install mysql-workbench from both Ubuntu-software center and via Terminal -
1.Ubuntu-Software_center prompt the following error-
    This error could be caused by required additional software packages which are missing or not installable. Furthermore there could be a conflict between software packages which are not allowed to be installed at the same time.
     mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9-20140406-0ubuntu1 is to be installed
                 Depends: libgtkmm-2.4-1c2a (>= 1:2.24.0) but 1:2.24.4-1ubuntu1 is to be installed
                 Depends: libpcrecpp0 (>= 7.7) but 1:8.31-2ubuntu2 is to be installed
                 Depends: python:any (>= 2.7.1-0ubuntu2) but it is a virtual package
                 Depends: mysql-workbench-data (= 6.0.8+dfsg-2) but 6.0.8+dfsg-2 is to be installed
2.Via Terminal it said -
    The following packages have unmet dependencies:
        mysql-workbench : Depends: mysql-client
        E: Unable to correct problems, you have held broken packages.

 Is there any workArround for installing it?

[pierophp (pierophp)]

A temporary solution:

Unpack mysql-workbench-community-6.1.4-1ubu1310-amd64.deb in a folder.

Change the file "DEBIAN/control", replace "mysql-client" to "mysql-client-5.6".

Go to the terminal and make a new ".deb":

dpkg -b mysql-workbench-community-6.1.4-1ubu1310-amd64/

Done! Now you can install from the new deb file.

[Michal Zubkowicz (michalzubkowicz)]

Little script for workaround from SO (copyright for user276521):
sudo apt-get remove mysql-workbench mysql-workbench-data
dpkg-deb -x mysql-workbench-community-6.*.deb tmp_mysql-workbench
dpkg-deb --control mysql-workbench-community-6.*.deb tmp_mysql-workbench/DEBIAN
sed -i -e 's/mysql-client, //' tmp_mysql-workbench/DEBIAN/control
dpkg -b tmp_mysql-workbench mysql-workbench-community_patched.deb
sudo dpkg -i mysql-workbench-community_patched.deb

[Rocko (rockorequin)]

Thanks for the workaround, it works well.

I guess then the generic fix for this bug so it works with either mysql 5.5 or mysql 5.6 would be to replace "mysql-client" with "mysql-client-5.5 | mysql-client-5.6" in DEBIAN/control.

[André Verwijs (dutchgigalo)]

SYSTEM:

OS: LinuxMint 17 (qiana) (Trusty based)
Gnome: 3.8.4 (Ubuntu 2014-03-17)
kernel: 3.13.0-24-generic (#47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014)
GCC version: 4.8 (x86_64-linux-gnu)
Xorg: 1.15.1 (16 April 2014 01:36:29PM)
Graphics: NVIDIA UNIX x86_64 Kernel Module 337.25 Tue May 27 11:05:28 PDT 2014
-----------------------------------------------------------------------------

if you download Workbench ( 6.1.7-1ubu1404 ) from official Mysql website ( http://dev.mysql.com/downloads/workbench/ )
and install, there's no problem...

Screenshot 1:
https://copy.com/o9dsUpuTel9c

Screenshot 2:
https://copy.com/CFYidlHpXeJ0

[Rocko (rockorequin)]

mysql-workbench 6.1.7-1ubu1404 from the official mysql site is the the one that I had to change DEBIAN/control to replace "mysql-client" with "mysql-client-5.5 | mysql-client-5.6". It wouldn't install in my Ubuntu otherwise because it depends on mysql-client, which is removed when you uninstall mysql-client-5.5. After I rebuilt it and changed the dependencies, it installed fine.

[Tj (kilrain)]

Downloading from official mysql website worked for me as well. They obviously fixed it.

[Rolf Leggewie (r0lf)]

mysql-client up to utopic depends on version 5.5. Vivid and beyond already depend on 5.6 and thus be only affected if mariadb is installed instead of mysql. This ticket can either be fixed by relaxing the dependencies in mysql-workbench or having mariadb and other packages provide mysql-client. Of course, both of these fixes can be done at the same time as well for the most robust solution.

[Rolf Leggewie (r0lf)]

mysql-5.6 in vivid and later is not affected. Closing the task as fixed. It would be nice to see a backported fix for trusty to the 0ubuntuX type package here.

[Rolf Leggewie (r0lf)]

Actually, this whole problem has been fixed in Debian unstable about 1 year ago.

mysql-workbench (6.2.3+dfsg-7) unstable; urgency=low

  * Demoted "virtual-mysql-client" to Recommends; added "mysql-client"
    as first alternative: "mysql-client | virtual-mysql-client".

 -- Dmitry Smirnov <email address hidden> Sun, 02 Nov 2014 08:07:54 +1100

This problem is fixed in vivid and beyond. We should backport a fix to trusty.

[Rolf Leggewie (r0lf)]

I can say that the compilation was successful and the program runs fine here. I did not spot any issues so far. I do have mariadb-client installed, though.

[Rolf Leggewie (r0lf)]

relevant packaging changes in Debian:
http://anonscm.debian.org/cgit/collab-maint/mysql-workbench.git/commit/?id=90404d3035107bf206928cb67b4ae3ec55f147e8
http://anonscm.debian.org/cgit/collab-maint/mysql-workbench.git/commit/?id=bf5b2421f61b5797e7446de93d97e6cfc9fa33ef

[Rolf Leggewie (r0lf)]

ping Ubuntu SRU team