Re: Mysql failed
On 11/16/16, Tony van der Hoff <tony@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 *
Reply to: