Friday, September 29, 2006

Access denied for user 'root'@'localhost' (using password: NO)


If you are getting this error messege while accessing mysql from the shell then make sure that you have done
su -
from the command prompt after that fire
even if you are getting that error messege then you need to reset the mysql password you can use following steps for it

first locate your mysql’s file then

kill `cat /mysql-data-directory/`
mysqld_safe –skip-grant-tables &
mysqladmin -u root flush-privileges password “newpassword”

New password will be the password that you want to set now.

Cheap Dedicated server
Cheap Dedictaed Server hosting


Blogger Simon said...

According to the mysql manual, the mysqladmin command is incorrect. I tried this and failed, but instead solved my problem using

8:25 AM  

Post a Comment

<< Home