☰

(K)Ubuntu 16.04無法安裝mysql伺服器未滿足的依賴關係

tag-icon • tag-icon apt package-management dpkg mysql
(K)Ubuntu 16.04無法安裝mysql伺服器未滿足的依賴關係

當我嘗試時，sudo apt-get install mysql-server我不斷收到以下錯誤：

    The following packages have unmet dependencies:
 mysql-server : Depends: mysql-community-server (= 5.7.12-1ubuntu15.10) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

不知道如何處理

當我嘗試安裝 mysql-community-server 時，我得到：

    The following packages have unmet dependencies:
 mysql-community-server : Depends: mysql-client (= 5.7.12-1ubuntu15.10) but it is not going to be installed
                          Depends: libmecab2v5 (>= 0.996-1.1ubuntu1)
E: Unable to correct problems, you have held broken packages.

然後在安裝mysql-client時：

    Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  mysql-common mysql-community-client
The following packages will be REMOVED:
  mysql-client-core-5.7
The following NEW packages will be installed:
  mysql-client mysql-community-client
The following packages will be upgraded:
  mysql-common
1 upgraded, 2 newly installed, 1 to remove and 11 not upgraded.
Need to get 0 B/7705 kB of archives.
After this operation, 32,4 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
(Reading database ... 177480 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.12-1ubuntu15.10_amd64.deb ...
Unpacking mysql-common (5.7.12-1ubuntu15.10) over (5.7.12-0ubuntu1) ...
dpkg: error processing archive /var/cache/apt/archives/mysql-common_5.7.12-1ubuntu15.10_amd64.deb (--unpack):
 trying to overwrite '/usr/share/mysql/russian/errmsg.sys', which is also in package mysql-server-core-5.7 5.7.12-0ubuntu1
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-common_5.7.12-1ubuntu15.10_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

運行後dpkg -l | grep mysql我得到：

ii  akonadi-backend-mysql                           4:15.12.3-0ubuntu6                         all          MySQL storage backend for Akonadi
ii  libmysqlclient20:amd64                          5.7.12-0ubuntu1                            amd64        MySQL database client library
ii  libqt4-sql-mysql:amd64                          4:4.8.7+dfsg-5ubuntu2                      amd64        Qt 4 MySQL database driver
ii  libqt5sql5-mysql:amd64                          5.5.1+dfsg-16ubuntu7                       amd64        Qt 5 MySQL database driver
ii  mysql-apt-config                                0.7.2-1                                    all          Auto configuration for MySQL APT Repo.
ii  mysql-client-core-5.7                           5.7.12-0ubuntu1                            amd64        MySQL database core client binaries
ii  mysql-common                                    5.7.12-0ubuntu1                            all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server-core-5.7                           5.7.12-0ubuntu1                            amd64        MySQL database server binaries

答案1

答案在評論中，但我認為值得將其發佈在那裡。

我從dev.mysql.com 下載了mysql-apt-config_0.7.2-1_all.deb （MySQL APT 儲存庫- dev.mysql.com/downloads/repo/apt），在設定過程中我選擇了Ubuntu Wily，因為16.04 不在列表。這就是問題所在，Xenial 的官方儲存庫中已經有 MySQL 5.7。

我通過運行修復了它sudo apt-get purge mysql-apt-config，然後sudo apt install mysql-server。

我想指出你應該感謝弗克拉伊姆， 不是我。

答案2

我遇到了同樣的問題，但沒有任何效果，對我來說最簡單、最快的方法是使用以下命令從系統中刪除 MySQL：

sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt-get autoremove
sudo apt-get autoclean

並再次安裝它：

curl -OL https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
sudo dpkg -i mysql-apt-config*
sudo apt update
sudo apt install mysql-server -y

這對我有用，除了由於 Ubuntu eoan 19.10 導致相容性問題之外，沒有更多問題。我最初將此發佈於這裡，供大家參考。希望我能提供協助。

相關內容