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

first locate your mysql’s hostname.pid file then

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

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

This entry was posted on Wednesday, April 11th, 2007 at 2:41 pm and is filed under PHP/Mysql Hosting. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.