Install MySQL Server after an upgrade from Ubuntu 14.04 to 16.04

What a terrible experience on an upgrade. Problem after problem. I finally got the network up, got PHP and Apache installed, but now after more hours of failed attempts, the closest I've got to mysql server install is this:

root@Hephaestus:~# sudo apt-get install mysql-server -y
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 to resolve the situation:

The following packages have unmet dependencies:
mysql-server : Depends: mysql-community-server (= 8.0.18-1ubuntu16.04) but it d
E: Unable to correct problems, you have held broken packages.

Any advice. I've tried purging, clearing, updating, etc.

1 Reply

I ran into a similar situation recently with an upgrade from Ubuntu 16.04 to 18.04. I never did figure out how to get things working without starting over from scratch. Hopefully, you backed up your database(s) before starting your upgrade. Assuming you did that, I got things working by completely removing and purging mysql-client and mysql-server. I then flushed the apt cache completely and made sure that dpkg wasn't showing any remnants (dpkg -l didn't show anything with 'rc' status). Then I checked my repositories to make sure I was using the appropriate sources (should be xenial for 16.04). I did a "sudo apt-get update" to retrieve current package information. Then I re-installed mysql-client and mysql-server. After recovering my databases I was good to go.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct