6

When I try to sudo apt-get install mysql-server I keep getting following error:

    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.

and have no idea how to deal with it

When i try to install mysql-community-server i get:

    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.

And then when installing 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)

After running dpkg -l | grep mysql I get:

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
6
  • 1
    Do you have any unofficial repositories enabled?
    – fkraiem
    May 5, 2016 at 12:07
  • I downloaded mysql-apt-config_0.7.2-1_all.deb (MySQL APT repository - dev.mysql.com/downloads/repo/apt) from dev.mysql.com and during config I have chosen Ubuntu Wily since 16.04 was not on the list. May 5, 2016 at 12:09
  • 3
    Well, that's your problem right there. You don't need to do that, Xenial already has MySQL 5.7 in its official repositories.
    – fkraiem
    May 5, 2016 at 12:11
  • How can I fix that then ? May 5, 2016 at 12:11
  • 1
    I'd say uninstall this mysql-apt-config package, and remove any unofficial repositories it added.
    – fkraiem
    May 5, 2016 at 12:13

2 Answers 2

6

The answer is in the comments, but I think It is worth to post it there.

I downloaded mysql-apt-config_0.7.2-1_all.deb (MySQL APT repository - dev.mysql.com/downloads/repo/apt) from dev.mysql.com and during config I have chosen Ubuntu Wily since 16.04 was not on the list. And that was the problem, Xenial already has MySQL 5.7 in its official repositories.

I fixed it by running sudo apt-get purge mysql-apt-config and then sudo apt install mysql-server.

I want to point that You should thank fkraiem, not me.

-1

I had the same problem and nothing worked for me, the easiest and fastest way for me was to erase MySQL from system with this commands:

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

and install it again, with:

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

That worked for me, aside from having a compativility problem because of Ubuntu eoan 19.10 there were no more problems. I posted originally this in here, for you to take it as a reference. Hope I was able to help.

2
  • Thank you very much for your review. I will edit it ASAP. Apr 20, 2020 at 6:42
  • @David better? Looking for your feedback (Y) Apr 20, 2020 at 6:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .