Re: mysql root user password, and Debian updates

[Fraser Campbell <fraser@wehave.net>]

stan wrote:

> Setting up mysql-server (3.23.52-2) ...
> Stopping MySQL database server: mysqld.
> dpkg: error processing mysql-server (--configure):
> subprocess post-installation script returned error exit status 1
> Errors were encountered while processing:
> mysql-server
> E: Sub-process /usr/bin/dpkg returned an error code (1)

I have a file /etc/mysql/debian.cnf, it contains this (password changed):

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = XXXXXXXXXXXXX

changelog.Debian shows that this was added at version 3.23.47-3 so it should 
work for you.  According to /usr/share/doc/mysql-server/README.Debian:

    You may never ever delete the special "debian-sys-maint" user. This user
    together with the credentials in /etc/mysql/debian.cnf are used by the
    init scripts to stop the server as they would require knowledge of the
    mysql root users password else.

Make sure that you have that file, if you don't set it up and add the 
appropriate mysql user to see if things improve.

-- 
Fraser