Announcement

Collapse
No announcement yet.

How can i fix this error.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can i fix this error.

    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

  • #2
    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

    Comment


    • #3
      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
      Last edited by sasskass; 12-02-2009, 04:32 PM.

      Comment

      Working...
      X