如何解密MySQL密码 [英] How can I decrypt MySQL passwords

问题描述

创建了公司使用的平台的开发人员不再为我们工作，而且我不知道如何从自定义PHP应用程序中检索密码

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

当我查看PHPmyAdmin时，密码已加密(例如* 2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19)

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

如何更改或检索这些?

推荐答案

如果使用了正确的加密方法，将无法轻松地检索它们.

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

只需使用新密码重置即可.

Just reset them with new passwords.

该字符串看起来像是使用 PASSWORD() :

The string looks like it is using PASSWORD():

UPDATE user SET password = PASSWORD("newpassword");

这篇关于如何解密MySQL密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！