package mysql-server-5.7 5.7.20-0ubuntu0.17.10.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Murad Bougarne]

I get this error in updating the mysql or upgrading the os

ProblemType: Package
DistroRelease: Ubuntu 17.10
Package: mysql-server-5.7 5.7.20-0ubuntu0.17.10.1
ProcVersionSignature: Ubuntu 4.13.0-16.19-lowlatency 4.13.4
Uname: Linux 4.13.0-16-lowlatency x86_64
ApportVersion: 2.20.7-0ubuntu3.1
Architecture: amd64
Date: Wed Nov 15 02:23:04 2017
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2017-08-14 (92 days ago)
InstallationMedia: Ubuntu 16.04.3 LTS "Xenial Xerus" - Release amd64 (20170801)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ib_logfile0', 'octoma', 'mysql', 'ibtmp1', 'myshares', 'ib_logfile1', 'loginsys', 'ibdata1', 'phpcms', 'shareapss', 'world', 'terminal_db', 'wpdev', 'auto.cnf', 'sys', 'phpstore', 'searchengine', 'debian-5.7.flag', 'performance_schema', 'test_db', 'ib_buffer_pool', 'oophp']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.13.0-16-lowlatency root=UUID=261d0735-99b0-495d-89e1-67c4da831dc9 ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.6, Python 3.6.3, python3-minimal, 3.6.3-0ubuntu2
PythonDetails: /usr/bin/python2.7, Python 2.7.14, python-minimal, 2.7.14-2ubuntu1
RelatedPackageVersions:
 dpkg 1.18.24ubuntu1
 apt 1.5.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.20-0ubuntu0.17.10.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to artful on 2017-11-15 (0 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Ricardo S O Leite (ricsdeol)]

Hi this issue happened with me.

Update Log:

╰─○ sudo dpkg -a --configure
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.17.10.1) ...
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
mysql_upgrade failed with exit status 11
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent 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
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server

However i can start mysql server:

╭─ricsdeol at ricsdeol-solvian in ~ using ‹ruby-2.4.0› 18-01-23 - 9:23:00
╰─○ sudo systemctl start mysql.service
╭─ricsdeol at ricsdeol-solvian in ~ using ‹ruby-2.4.0› 18-01-23 - 9:23:12
╰─○ sudo systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)
   Active: active (running) since Tue 2018-01-23 09:23:12 -02; 3s ago
  Process: 3674 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
  Process: 3649 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 3673 (mysqld)
    Tasks: 28 (limit: 4915)
   Memory: 161.5M
      CPU: 407ms
   CGroup: /system.slice/mysql.service
           └─3673 /usr/sbin/mysqld

jan 23 09:23:08 ricsdeol-solvian systemd[1]: Starting MySQL Community Server...
jan 23 09:23:12 ricsdeol-solvian systemd[1]: Started MySQL Community Server.

[Joshua Powers (powersj)]

From terminal log:

mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) while connecting to the MySQL server

This looks like a duplicate of bug 1607938. I am marking it as such. If you disagree or have further information feel free to respond to this bug.