Update password in MySQL

Hello,

I have a PHP/MySQL app installed on my site. I've forgotten my password, but the password in the MySQL table is encrypted. How do I encrypt a new password and/or decrypt the old password to see what it is?

Thanks,
Adam

 

SELECT PASSWORD('new_password');

More about it...

 

Nevermind.

 

If you'd like to send me the encrypted password I may be able to decrypt it for you.

 

You should know which algorithm your password encrypted. There is a simple way is that:
go to your mysql database and delete the old password. Now you can login with the blank password.
Hope it's useful.

 

Hmmm. That didn't work. Possibly because the script won't allow a blank password input?

 

what type of encripted you use to encript your password .....md5 and some other encryption method can't be able to decript back to see the password.

If you want to encrypt your password ...then see MD5() and SHA1() in PHP

 

There are tools to generate encrypted passwords so you can create a new one a copy/paste over the old one