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
dBforums
>
MySQL fails to start
06-22-08, 22:15
Linear Mode
