N/APosted 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)"
MySQL Error 1045 Access Denied
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.
For the second error I found out an interesting article, I hope this will helpful
trouble shoot second error