MySQL Error 1045 Access Denied

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

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: 1436
• 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

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