Home / server / Questions / 340548
In Process
aidan
Asked: 2011-12-14 09:06:29 +0800 CST

MySQL update fatal error on AWS Ubuntu server

  • 772

I was just browsing the system logs on my alestic Ubuntu 10.04 AWS EC2 production server, and found this:

daemon.log.1:Dec  9 22:45:42 server1 /etc/mysql/debian-start[865]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
daemon.log.1:Dec  9 22:45:42 server1 /etc/mysql/debian-start[865]: FATAL ERROR: Upgrade failed

I'm assuming it came from a routine apt-get dist-upgrade. Is this something I need to address? It looks serious.

ubuntu mysql amazon-ec2 apt amazon-web-services

1 Answers

  1. it looks like you deleted the debian-sys-maint user, or the password for this user needs to be reset. The init scripts use this account for stopping/starting and maintanence. It expects the password for this account to match the password found in /etc/mysql/debian.cnf. The user is typically created having all privileges.

    • 3