0

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: –
  • Please update your question with output of apt-cache policy libgdal1i libgdal.so.1-1.11.3. On my xenial it installs normally (just --simulated it). You have PPA or third-party repositories. – N0rbert Jan 13 '18 at 16:19
  • isaac@isaac-HP-Laptop-15-bs0xx:~$ apt-cache policy libgdal1i libgdal.so.1-1.11.3libgdal1i: 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: – Isaac A Jan 15 '18 at 15:07
  • I suggest to switch to other mirror with Software & Updates (software-properties-gtk). – N0rbert Jan 15 '18 at 15:31
  • What mirror should I choose? – Isaac A Jan 15 '18 at 15:52
  • Start with Main server. – N0rbert Jan 15 '18 at 15:54
1

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.

0

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

  • Hello N0rbert, thank you for your help! Question. When I want to save something in terminal, what do I press? Ctrl+S? Esc? Q? – Isaac A Jan 15 '18 at 20:44
  • Use gedit (see update above). – N0rbert Jan 15 '18 at 20:50
  • IT WORKS! Thank you so much! I guess this post post should be stickied. Are you on LinkedIn? – Isaac A Jan 15 '18 at 21:05
  • Alright, now I have another question. I am trying to set up a connection, and I get the following error: Connecting to MySQL server ... Can't connect to MySQL server on '127.0.0.1' (111) – Isaac A Jan 15 '18 at 21:11
  • You should use search here on just google to solve connection issues. It is another question. – N0rbert Jan 16 '18 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.