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

[fasil KM]

Hello all,
Found a solution for the issue...please follow these
1. be sure that mysql server is running
2. edit the file /etc/my.cnf
2.1 - under [mysqld] section, add the line 'skip-grant-tables'
2.2 - save the file
3. restart mysql server
4. now you will be able to login using 'mysql -u root' and you should get the mysql prompt.

If u want to reset the password of the root user for mysql follow the steps below:
1. mysql> UPDATE user SET Password=PASSWORD('new_password') where USER='root';
where 'new_password' is the new password for the user: root.
2. mysql> exit;
3. remove the 'skip-grant-tables' line from /etc/my.cnf
4. restart mysql server again
5. now login using 'mysql -u root -p'
6. password: <type in your new password>
7. you should get the mysql prompt

Enjoyyy!!!!!!!!!!