Mysql failed
Hi,
I've just discovered that MySQL on my jessie desktop box has died
unexpectedly. I'm pretty sure it was working 3/4 days ago.
################################################
tony@tony-lx:~$ mysql -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
################################################
Sure enough, that socket doesn't exist.
sudo service mysql start returns immediately; no errors in any log.
It looks like mysql server is no longer installed:
################################################
root@tony-lx:~# dpkg-query -l 'mysql*'
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version
Architecture Description
+++-=====================================================-===============================-===============================-===============================================================================================================
un mysql-client <none>
<none> (no description available)
un mysql-client-5.0 <none>
<none> (no description available)
un mysql-client-5.1 <none>
<none> (no description available)
ii mysql-client-5.5
5.5.50-0+deb8u1 amd64 MySQL
database client binaries
ii mysql-common
5.6.30-1~bpo8+1 all MySQL
database common files, e.g. /etc/mysql/my.cnf
un mysql-common-5.6 <none>
<none> (no description available)
un mysql-server <none>
<none> (no description available)
un mysql-server-5.0 <none>
<none> (no description available)
un mysql-server-5.1 <none>
<none> (no description available)
rc mysql-server-5.5
5.5.53-0+deb8u1 amd64 MySQL
database server binaries and system database setup
un mysql-server-core <none>
<none> (no description available)
un mysql-server-core-5.5 <none>
<none> (no description available)
ii mysql-utilities 1.3.5-2
all collection of scripts
for managing MySQL servers
ii mysql-workbench 6.2.3+dfsg-7
amd64 MySQL Workbench - a
visual database modeling, administration and queuing tool
ii mysql-workbench-data 6.2.3+dfsg-7
all MySQL Workbench --
architecture independent data
################################################
I believe there was an update to mysql package, which
unattended-upgrades would have tried to install, and maybe it failed.
The mysql server is certainly missing.
So, try re-installing:
################################################
root@tony-lx:~# apt-get -f install mysql-server-5.5
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-5.5 : Depends: mysql-client-5.5 (>= 5.5.50-0+deb8u1) but
it is not going to be installed
PreDepends: mysql-common (>= 5.5.50-0+deb8u1) but
it is not going to be installed
E: Unable to correct problems, you have held broken packages.
################################################
but they ARE installed!!
Any suggestions as to what to do next, please?
--
Tony van der Hoff | mailto:tony@vanderhoff.org
Buckinghamshire, England |
Reply to: