How can i fix this error.

[sasskass]

After backup restore to a new machine, got this error on every reboot:
-----------------------

Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 InnoDB: Started; log sequence number 0 7827358
Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Starting crash recovery...
Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] Crash recovery finished.
Dec 2 06:02:58 mail mysqld[4430]: 091202 6:02:58 [Note] /usr/sbin/mysqld: ready for connections.
Dec 2 06:02:58 mail mysqld[4430]: Version: '5.0.32-Debian_7.5.200902111628-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Dec 2 06:02:59 mail /etc/mysql/debian-start[4485]: Upgrading MySQL tables if necessary.
Dec 2 06:02:59 mail /etc/mysql/debian-start[4488]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
Dec 2 06:02:59 mail /etc/mysql/debian-start[4488]: Error executing '/usr/bin/mysql --defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults --force --no-auto-rehash --batch --user=debian-sys-m
aint mysql < /usr/share/mysql/mysql_fix_privilege_tables.sql'
Dec 2 06:02:59 mail /etc/mysql/debian-start[4494]: Checking for crashed MySQL tables.
Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: WARNING: mysqlcheck has found corrupt tables
Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]:
Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: Improperly closed tables are also reported if clients are accessing
Dec 2 06:02:59 mail /etc/mysql/debian-start[4510]: the tables *now*. A list of current connections is below.
Dec 2
------------------------------------------

also on shutdown, the mysql daemon shows error shutting down.

Everything else seems to be working

[Martin Heiland]

Hi,

seems like you've also backupped and restored the "mysql" table. This one contains a debian user "debian-sys-maint" with a system-specific password. This user is required to start/stop mysql correctly. You might want to change its password to the one specified at /etc/mysql/debian.cnf.

Greetings

[sasskass]

Changing the password cli

Thanks for the reply Martin,

The backup/restore procedure was made using 100% UMC backup capability - nothing manually.
Experimentations with OX AE are not ending up very happily allways, so for example the passowd in /etc/mysql/debian.cnf is: 123456

so the right way to do it from the shell should be:
---------------------
mysql -u root

SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('123456');

flush privileges;
---------------------

Im i right ?


Aleksander