mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) while connecting to the MySQL server

Bug #1607938 reported by Gerardo Rico on 2016-07-29
84
This bug affects 17 people
Affects Status Importance Assigned to Milestone
mysql-5.7 (Ubuntu)
High
Unassigned

Bug Description

.

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 (not installed)
ProcVersionSignature: Ubuntu 4.4.0-31.50-generic 4.4.13
Uname: Linux 4.4.0-31-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
Date: Wed Jul 27 18:12:22 2016
ErrorMessage: el subproceso instalado el script post-installation devolvió el código de salida de error 1
InstallationDate: Installed on 2016-07-25 (3 days ago)
InstallationMedia: Ubuntu 16.04.1 LTS "Xenial Xerus" - Release amd64 (20160719)
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.1
 apt 1.2.12~ubuntu16.04.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 (not installed) failed to install/upgrade: el subproceso instalado el script post-installation devolvió el código de salida de error 1
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2016-07-13T21:55:42
mtime.conffile..etc.init.d.mysql: 2016-07-13T20:10:16
mtime.conffile..etc.logrotate.d.mysql-server: 2016-07-13T20:10:16
mtime.conffile..etc.mysql.debian-start: 2016-07-13T21:55:42

Gerardo Rico (g-rico-c) wrote :
Robie Basak (racb) wrote :

From log:

mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
mysql_upgrade failed with exit status 11
dpkg: error al procesar el paquete mysql-server-5.7 (--configure):
 el subproceso instalado el script post-installation devolvió el código de salida de error 1

summary: - package mysql-server-5.7 (not installed) failed to install/upgrade: el
- subproceso instalado el script post-installation devolvió el código de
- salida de error 1
+ mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-
+ maint'@'localhost' (using password: YES) while connecting to the MySQL
+ server
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in mysql-5.7 (Ubuntu):
status: New → Confirmed
Lars Tangvald (lars-tangvald) wrote :

Users might have blocked access for debian-sys-maint somehow, simply because they don't want the maintainer scripts to have access to the database. I don't think this is an invalid choice, so we might consider giving a warning instead of error in the specific case of access denied.

Please:

1. Edit the description, so it explains the steps to recreate the bug and the consequences of it.
2. Set status back to "confirmed".

Thank you.

Changed in mysql-5.7 (Ubuntu):
status: Confirmed → Incomplete
Robie Basak (racb) wrote :

@Alberto,

Lars and I maintain MySQL packaging in Debian and Ubuntu. Even though we do not yet know how to reproduce it, we think this is a valid bug since there are multiple reports, so Confirmed is the correct status.

Changed in mysql-5.7 (Ubuntu):
status: Incomplete → Confirmed
Changed in mysql-5.7 (Ubuntu):
importance: Undecided → High
Lars Tangvald (lars-tangvald) wrote :

This is _probably_ a duplicate of LP: #1567612

Micha Grandel (michagrandel) wrote :

I got the same error yesterday. I installed mariadb in the past, but forgot about this and then tried to use and install mysql. My solution was a complete uninstall of mysql and mariadb and a clean install of mariadb. Especially the fact that Gerardo tries to connect to a mysql server, but mysql-server-5.7 is not installed on his/her machine makes me think that mariadb might be involed, because I got equal error messages.

Maybe this is related to #1490071

my setup: ubuntu 16.04, amd64, mysql Ver 15.1 Distrib 10.0.29-MariaDB

Robie Basak (racb) on 2017-03-06
tags: added: triage
To post a comment you must log in.