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

[omkar gavhane]

omkar@omz:~$ sudo service mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: e
   Active: inactive (dead)

Sep 09 23:35:05 omz systemd[1]: Starting MySQL Community Server...
Sep 09 23:35:06 omz systemd[1]: Started MySQL Community Server.
Sep 09 23:42:38 omz systemd[1]: Stopping MySQL Community Server...
Sep 09 23:42:40 omz systemd[1]: Stopped MySQL Community Server.

ProblemType: Package
DistroRelease: Ubuntu 18.04
Package: mysql-server-5.7 5.7.23-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-33.36-generic 4.15.18
Uname: Linux 4.15.0-33-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.3
Architecture: amd64
Date: Sun Sep 9 23:53:25 2018
ErrorMessage: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
Logs.var.log.daemon.log:

Logs.var.log.mysql.error.log:
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-33-generic root=UUID=7012fc2b-01d7-4e2e-acad-7a641aa3de7e ro quiet splash vt.handoff=1
Python3Details: /usr/bin/python3.6, Python 3.6.5, python3-minimal, 3.6.5-3ubuntu1
PythonDetails: /usr/bin/python2.7, Python 2.7.15rc1, python-minimal, 2.7.15~rc1-1
RelatedPackageVersions:
 dpkg 1.19.0.5ubuntu2
 apt 1.6.3ubuntu0.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.23-0ubuntu0.18.04.1 failed to install/upgrade: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Andreas Hasenack (ahasenack)]

Thanks for filing this bug in Ubuntu.

The logs show that mysql failed to start because it's missing its configuration directory:
ERROR: Unable to start MySQL server:
mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - No such file or directory)
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

Did you remove that directory?

Did you switch back and forth between mysql and mariadb?

[Launchpad Janitor (janitor)]

[Expired for mysql-5.7 (Ubuntu) because there has been no activity for 60 days.]