☰

MySQL 未满足的依赖关系

tag-icon • tag-icon apt package-management upgrade mysql dependencies
MySQL 未满足的依赖关系

我尝试安装 MySQL-Workbench，但出现以下错误。我该如何解决？

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: –

答案1

看来您的 内容有误/etc/apt/sources.list。

1.请用 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

使用以下正确的行：

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.保存结果/etc/apt/sources.list
3.运行sudo apt-get update
4.安装最新更新sudo apt-get upgrade
5.安装您的软件sudo apt-get install mysql-workbench

答案2

解决方案如下（请按照相应步骤操作）：

1）如何卸载 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/

所以，我首先应该做的是配置 mysql 服务器，然后再安装 mysql 工作台。

相关内容