package mysql-server 5.1.30really5.0.75-0ubuntu10 failed to install/upgrade: subprocess pre-installation script returned error exit status 1

[Klaas van Schelven]

Update Manager failed to upgrade mysql server for some reason.

Didn't look in to it really, just clicked the various "report" buttons that popped up.

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess pre-installation script returned error exit status 1
Package: mysql-server 5.1.30really5.0.75-0ubuntu10
PackageArchitecture: all
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server 5.1.30really5.0.75-0ubuntu10 failed to install/upgrade: subprocess pre-installation script returned error exit status 1
Uname: Linux 2.6.28-11-generic i686

[Mathias Gug (mathiaz)]

Relevant error messages:

Preparing to replace mysql-server 5.1.30really5.0.75-0ubuntu10 (using .../mysql-server_5.1.30really5.0.75-0ubuntu10.2_all.deb) ...
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.

Could you post the content of /var/log/daemon.log around the time of the upgrade to identify why mysqld has failed to be stopped?

[Klaas van Schelven (klaas-vanschelven)]

Jun 2 10:16:07 leopard mysqld_safe[2563]: started
Jun 2 10:16:07 leopard mysqld[2567]: 090602 10:16:07 InnoDB: Started; log sequence number 0 6231594
Jun 2 10:16:07 leopard mysqld[2567]: 090602 10:16:07 [Note] /usr/sbin/mysqld: ready for connections.
Jun 2 10:16:07 leopard mysqld[2567]: Version: '5.0.75-0ubuntu10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2605]: Upgrading MySQL tables if necessary.
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: Looking for 'mysql' as: /usr/bin/mysql
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: Running 'mysqlcheck'...
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using pas
sword: YES) when trying to connect
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: FATAL ERROR: Upgrade failed
Jun 2 10:16:08 leopard /etc/mysql/debian-start[2641]: Checking for insecure root accounts.

[Mathias Gug (mathiaz)]

Relevant error message:

Jun 2 10:16:08 leopard /etc/mysql/debian-start[2611]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect

The debian-sys-maint user is required by the init script.