Home / ubuntu / Questions / 995333
Accepted
Isaac A
Asked: 2018-01-13 13:31:15 +0800 CST

MySQL unmet dependicies

  • 772

I tried installing MySQL-Workbench and I get the following errors. How do I solve them?

isaac@isaac-HP-Laptop-15-bs0xx:~$ sudo apt update && sudo apt upgrade
[sudo] password for isaac: 
Hit:1 http://archive.ubuntu.mirror.rafal.ca/ubuntu xenial InRelease
Hit:2 http://ppa.launchpad.net/hanipouspilot/rtlwifi/ubuntu xenial InRelease 
Hit:3 http://download.virtualbox.org/virtualbox/debian xenial InRelease        

Hit:4 http://ppa.launchpad.net/jonathonf/python-3.6/ubuntu xenial InRelease    
Hit:5 http://ppa.launchpad.net/umang/indicator-stickynotes/ubuntu xenial InRelease
Hit:6 http://ppa.launchpad.net/webupd8team/y-ppa-manager/ubuntu xenial InRelease
Reading package lists... Done
Building dependency tree       
Reading state information... Done
All packages are up to date.
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

isaac@isaac-HP-Laptop-15-bs0xx:~$ sudo apt install mysql-workbench
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 resolve the situation:

The following packages have unmet dependencies:
mysql-workbench : Depends: libgdal.so.1-1.11.3
               Depends: libgdal1i (>= 1.8.0) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.


isaac@isaac-HP-Laptop-15-bs0xx:~$ apt-cache policy libgdal1i libgdal.so.1-1.11.3

libgdal1i: 
    Installed: (none) 
    Candidate: 1.11.3+dfsg-3build2 
    Version table: 1.11.3+dfsg-3build2 
    500 500 http://archive.ubuntu.mirror.rafal.ca/ubuntu xenial/universe amd64 Packages 

libgdal.so.1-1.11.3: 
    Installed: (none)
    Candidate: (none)
    Version table: –
apt

2 Answers

  1. It seems that you have wrong contents of your /etc/apt/sources.list.

    1.Please replace your lines with Gedit - sudo gedit /etc/apt/sources.list

    deb http://ca.archive.ubuntu.com/ubuntu/ xenial multiverse main universe restricted 
deb http://archive.canonical.com/ xenial partner

    with these correct lines:

    deb http://archive.ubuntu.com/ubuntu xenial main restricted universe multiverse
deb http://archive.ubuntu.com/ubuntu xenial-updates main restricted universe multiverse
deb http://archive.ubuntu.com/ubuntu xenial-backports main restricted multiverse universe
deb http://archive.ubuntu.com/ubuntu xenial-security main restricted multiverse

    2.save resulting /etc/apt/sources.list
    3.run sudo apt-get update
    4.install latest updates with sudo apt-get upgrade
    5.install your software with sudo apt-get install mysql-workbench

    • 1
  2. Best Answer

    Solution is the following (please follow the steps accordingly):

    1) How do I uninstall MySQL?

    2) https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04#step-1-%E2%80%94-installing-mysql

    3) https://linode.com/docs/databases/mysql/install-and-configure-mysql-workbench-on-ubuntu/

    So, what I should have initially done is configure the mysql server and only then install the mysql workbench.

    • 1