MySQL problem

satimis · #1 (**permalink**) Jun 23rd, 2008, 02:29

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: Select all

......
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: Select all

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: Select all

 * Stopping MySQL database server mysqld       [fail]

$ sudo netstat -tap | grep mysql

Code: Select all

tcp        0      0 *:mysql       *:*     LISTEN     4760/mysqld

It seems MySQL is running. Maybe on safe_mode?

$ su
Password:
# mysql -u root -p

Code: Select all

Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)

# mysql -u root

Code: Select all

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

CloudedVision · #2 (**permalink**) Jun 26th, 2008, 03:52

WebForumz probably won't be able to help you, none of us (save few) are experts on linux. I would recommend Ubuntu Forums.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP problem in Apache/PHP/MySQL	JohnI	PHP Forum	6	Aug 7th, 2008 10:26
Asp.net insert to mysql problem	boyindie	ASP.NET Forum	1	Aug 24th, 2007 02:00
mySQL - PHP (problem) - XML - Flash	photofx	PHP Forum	3	Jul 27th, 2007 17:43
PHP-MySQL problem	robertboyle	PHP Forum	4	Jun 16th, 2006 13:02
Mysql sorting problem....	mills	Databases	2	Jul 26th, 2005 09:08

		Webforumz.com > Main Forums > Program Your Website > Databases
MySQL problem