Mike Mike - 2 years ago 98
MySQL Question

How can I decrypt MySQL passwords

The developer who created a platform my company uses is no longer working for us and I don't know how I can retrieve the passwords from a custom PHP application

When I look in the PHPmyAdmin the passwords are ecrypted (eg *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19)

How can I change or retrieve these?

Answer Source

If a proper encryption method was used, it's not going to be possible to easily retrieve them.

Just reset them with new passwords.

Edit: The string looks like it is using PASSWORD():

UPDATE user SET password = PASSWORD("newpassword");
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download