On 11/16/16, Tony van der Hoff <t...@vanderhoff.org> wrote: > 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: > > < snipped for brevity > > > 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?
What about "apt-get install --reinstall" to see if that does anything different from the "-f" flag? For purposes of archiving for others, anyone have any insight into the yes/no advisability as to why you would or would not do so? I'm trying to remember if I've had any circumstances where I've tried both, and I can't remember anything with memorable outcome. :) Just before sending this off, it occurred me to that I *do* remember that once in a while "dpkg" will have success with something like this when "apt-get" does not.... Cindy :) -- Cindy-Sue Causey Talking Rock, Pickens County, Georgia, USA * runs with duct tape *
