I resolved this by resetting the debian-sys-maint password:

mysql -u root -p mysql
...
set password for 'debian-sys-maint'@'localhost'=$password

were $password is the one listed in /etc/mysql/debian.cnf.

The error message is incorrect in this case:

Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4114]: Upgrading 
MySQL tables if necessary.
Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4119]: ERROR 1045 
(28000): Access denied for user 'debi
an-sys-maint'@'localhost' (using password: YES)
Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4119]: 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'
Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4122]: Checking for 
crashed MySQL tables.
Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4131]: WARNING: 
mysqlcheck has found corrupt tables
Jan  8 10:20:21 [EMAIL PROTECTED] /etc/mysql/debian-start[4131]: 
/usr/bin/mysqlcheck: Got error: 1045: Access den
ied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying 
to connect


/Allan

Attachment: signature.asc
Description: Digital signature

Reply via email to