MySQL Error 1045 Access Denied - Techyv.com

Asked By expert13 0 points N/A Posted on - 09/30/2011

qa-featured

I have a Debian server, that I have installed LAMP. Everything was running smoothly. I was connecting through konsole to MySQL and through phpmyadmin without any problems until recently. For the last week, when I'm running 'etc/init.d/mysql start' from the konsole, I get the following message:

"Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables."

Also, when I'm running 'mysql' from the konsole, I get the following message:

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

Any ideas?

Status: Open
Question Views: 1429
Answer Count: 1
Vote Up 0 Vote Down

Answer Accepted: No
Question Category: MySQL Server

Answered By peetardoc 0 points N/A #83996

MySQL Error 1045 Access Denied

qa-featured

Hi,

So you are in the grad trouble with the MySQL server.

The first error, “Checking for corrupt, not cleanly closed and upgrade needing tables". This is not actually a technical error. Most of us do not exit from the MySQL console after the work is done. They just close the console.

When MySQL server is suddenly shutdown, the database table will be corrupted. The easy way of correcting this issue is reappearing the tables.

You can do it with two easy commands.

CHECK TABLE_NAME

REPAIR TABLE_NAME

For the second error I found out an interesting article, I hope this will helpful

trouble shoot second error

Thank you.

About peetardoc

Questions
0

Answers
3

Best Answers
0

Vote Up 0 Vote Down

Posted on - 10/16/2011
Question Category: MySQL Server

Login/Register to Answer

Lotus notes functionality as a workflow application

Bulletin board problem - Discus freeware