How to upgrade ubuntu to 18?

Question

ubuntu

Now I have ubuntu 16, I'm trying to update according to the instructions

sudo apt-get update
sudo apt-get install update-manager-core

writes to me

Setting up mysql-server-5.7 (5.7.31-0ubuntu0.16.04.1) ...
initctl: Unable to connect to Upstart: Failed to connect to socket /com/ubuntu/upstart: Connection refused
insserv: warning: script 'screen -cleanup' missing LSB tags and overrides
insserv: Default-Start undefined, assuming empty start runlevel(s) for script `screen-cleanup'
insserv: Default-Stop undefined, assuming empty stop runlevel(s) for script `screen-cleanup'
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1243: Unknown prepared statement handler (stmt) given to EXECUTE
mysql_upgrade failed with exit status 5
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess prevent installed post-installation script returned error exit status 1
dpkg: dependency problems configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

in fact, it also writes there is phpmyadmin to install ...
How can I reinstall it? you can even clean it, just so that the password remains the same ...

Answer 1

I advise you to edit the system packages through aptitude - pseudographics and cursor control are more convenient.
I usually edit /etc/apt/source.list configs - put the following name.
after that I update the lists of packages sudo apt update
, then I download all the packages to the cache, now of course the Internet is stable, but it's better to overdo it than to crap.sudo apt-get upgrade --download-only

Answer 2

Try following the instructions
https://www.rosehosting.com/blog/how-to-fix-broken...