On 2008-01-08T17:33:26+0100, Norbert Tretkowski wrote: > Am Dienstag, den 08.01.2008, 10:50 -0500 schrieb Allan Wind: > > I tried to connect to mysql using the information in > > /etc/mysql/debian.cnf and it did not work. > > That's the problem. Did you modify the password of the debian-sys-maint > user or the file /etc/mysql/debian.cnf in the past?
No, although I did have a password commented out in /etc/mysql/my.cnf: ... #password = ... password = ... ... and neither of them worked. > Starting mysqld manually and setting a new password for the mentioned > user (which you have to set in /etc/mysql/debian.cnf as well) should fix > this problem. It did. > I'm quite sure it's not related to the security update, something else > much have gone wrong on your system. The log provided shows the server starting up and shutting down just fine prior to the upgrade. Here's the aptitude log with the timestamp of the upgrade: Tue, Jan 8 2008 10:05:43 -0500 IMPORTANT: this log only lists intended actions; actions which fail due to dpkg problems may not be completed. Will install 6 packages, and remove 0 packages. 4096B of disk space will be used =============================================================================== [UPGRADE] libfreetype6 2.2.1-5+etch1 -> 2.2.1-5+etch2 [UPGRADE] libmysqlclient15off 5.0.32-7etch3 -> 5.0.32-7etch4 [UPGRADE] mysql-client-5.0 5.0.32-7etch3 -> 5.0.32-7etch4 [UPGRADE] mysql-common 5.0.32-7etch3 -> 5.0.32-7etch4 [UPGRADE] mysql-server 5.0.32-7etch3 -> 5.0.32-7etch4 [UPGRADE] mysql-server-5.0 5.0.32-7etch3 -> 5.0.32-7etch4 =============================================================================== Log complete. And the first sign of problem is here: Jan 8 10:06:12 [EMAIL PROTECTED] /etc/mysql/debian-start[3560]: Upgrading MySQL tables if necessary. Jan 8 10:06:12 [EMAIL PROTECTED] /etc/mysql/debian-start[3565]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) Jan 8 10:06:12 [EMAIL PROTECTED] /etc/mysql/debian-start[3565]: Error executing '/usr/bin/mysql --defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults --force --no-auto-rehash --batch --user=debian-sys-maint mysql < /usr/share/mysql/mysql_fix_privilege_tables.sql' This was not a production machine, so the only loss was the time to troubleshoot and share this knowledge. Others may have more important stuff in mysql. /Allan
signature.asc
Description: Digital signature
