且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

mysql使用什么样的哈希?

更新时间:1970-01-01 07:57:06

我不认为你将能够解密存储在 MySQL 表中的密码,使用存储在 mysql 中的密码也没有用代码>.用户代码>表.

I don't think you will be able to decrypt password stoed in MySQL table and it's of no use using password which is stored in mysql.user table.

您应该使用在您的应用程序中创建 User 时设置的密码,如果您丢失了用户密码,那么您可以使用 mysqladmin 重置它

You should be using password that is being set when User is created in your application, If you have lost password of users then you can reset it using mysqladmin

设置 'user-name-here'@'hostname-name-here' 的密码 = PASSWORD('new-password-here');

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');