MySQL - Canot reset password
 

All,

I have a strange problem. I setup mysql with two password access for the root command (localhost and the DNS name). Of course the DNS name works, but I need the localhost to work. I have been trying the standard methods of resetting this password:

1. killall mysqld
2. ./mysqld start --skip-grant-tables -user=root
3. OR ./mysqld start -Sg --user=root &

When I try to run mysql -u root to get the clean access so I can update the password, I still get the deny of access menssage:

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


This is killing me. Any other suggestions? I even tried the resolution from the MySQL Administrator support page, where you delete the .pid file assoicated to that mysql installation and then try and reset the password that way, but no dice.

There has to be a resolution for this issue.

Thanks in advance.

maybe this can help you, a little article written by a LQ member :
Click Here To View