package mariadb-server-10.0 10.0.31-0ubuntu0.16.04.2 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Ikhsan Teguh]

Icann't install phpmyadmin fluently, there is caution :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mariadb-server-10.0 10.0.31-0ubuntu0.16.04.2
ProcVersionSignature: Ubuntu 4.10.0-42.46~16.04.1-generic 4.10.17
Uname: Linux 4.10.0-42-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.14
Architecture: amd64
Date: Sun Dec 10 23:48:59 2017
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2017-12-10 (0 days ago)
InstallationMedia: Ubuntu 16.04.2 LTS "Xenial Xerus" - Release amd64 (20170215.2)
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
MySQLVarLibDirListing: ['performance_schema', 'debian-10.0.flag', 'ib_logfile1', 'aria_log_control', 'aria_log.00000001', 'ib_logfile0', 'mysql', 'ibdata1']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.10.0-42-generic root=UUID=1f2f5b8f-f606-4904-933f-8838cc0d22fc ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.3
 apt 1.2.24
SourcePackage: mariadb-10.0
Title: package mariadb-server-10.0 10.0.31-0ubuntu0.16.04.2 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Faustin (fauust)]

Hi Ikhsan,
thank you for your report.

Error seems to be:
Des 10 23:48:28 hostname mysqld[17086]: 171210 23:48:28 [ERROR] Can't start server : Bind on unix socket: Address already in use
Des 10 23:48:28 hostname mysqld[17086]: 171210 23:48:28 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
Des 10 23:48:28 hostname mysqld[17086]: 171210 23:48:28 [ERROR] Aborting

Can you check that no other mysql process is running?
$ ps fax | grep mysqld

Can you also give us the result of this command:
$ sudo file /var/run/mysqld/*

[Launchpad Janitor (janitor)]

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