Hi folks,


Ubuntu 7.04 server amd64
MySQL-5.0.38 installed on repo


It just comes to my notice that on booting PC a warning displayed on text scrolling indicates MySQL failure to start


$ cat /var/log/syslog | grep mysql
Code:
......
Jun 23 07:18:36 mail mysqld_safe[4758]: started
Jun 23 07:18:36 mail mysqld[4761]: 080623  7:18:36  InnoDB: Started; log sequenc
e number 0 43655
Jun 23 07:18:36 mail mysqld[4761]: 080623  7:18:36 [Note] Recovering after a cra
sh using /var/log/mysql/mysql-bin
Jun 23 07:18:36 mail mysqld[4761]: 080623  7:18:36 [Note] Starting crash recover
y...
Jun 23 07:18:36 mail mysqld[4761]: 080623  7:18:36 [Note] Crash recovery finishe
d.
Jun 23 07:18:36 mail mysqld[4761]: 080623  7:18:36 [Note] /usr/sbin/mysqld: read
y for connections.
Jun 23 07:18:36 mail mysqld[4761]: Version: '5.0.38-Ubuntu_0ubuntu1.4-log'  sock
et: '/var/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 7.04 distribution
Jun 23 07:18:37 mail /etc/mysql/debian-start[4798]: Upgrading MySQL tables if ne
cessary.
Jun 23 07:18:37 mail /etc/mysql/debian-start[4803]: ERROR 1045 (28000): Access d
enied for user 'debian-sys-maint'@'localhost' (using password: YES)
Jun 23 07:18:37 mail /etc/mysql/debian-start[4803]: Error executing ''/usr/bin/m
ysql' '--defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults' '--force' '-
-no-auto-rehash' '--batch' '--user=debian-sys-maint' '--database=mysql' < '/usr/
share/mysql/mysql_fix_privilege_tables.sql''
Jun 23 07:18:37 mail /etc/mysql/debian-start[4810]: Checking for crashed MySQL t
ables.
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]: WARNING: mysqlcheck has foun
d corrupt tables
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]: /usr/bin/mysqlcheck: Got err
or: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password:
 YES) when trying to connect
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]: 
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]:  Improperly closed tables ar
e also reported if clients are accessing
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]:  the tables *now*. A list of
 current connections is below.
Jun 23 07:18:38 mail /etc/mysql/debian-start[4858]:

I suppose the problem is caused by running several 'apt-get update' and 'apt-get upgrade'. Before MySQL start/stop without problem nor having warning.


On running following commands


$ sudo /etc/init.d/mysql status
Code:
Password:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: Y
ES)'

$ sudo /etc/init.d/mysql stop
Code:
 * Stopping MySQL database server mysqld       [fail]


$ sudo netstat -tap | grep mysql
Code:
tcp        0      0 *:mysql       *:*     LISTEN     4760/mysqld
It seems MySQL is running. Maybe on safe_mode?


$ su
Password:
# mysql -u root -p
Code:
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)

# mysql -u root
Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)

Even I can't login MySQL. Please advise how to fix this problem. TIA


B.R.
satimis