How to decrypt MYSQL password->user - >password

The password in the database is stored as F40A1DD8BD13322642527D1ADC22FA6DF1B1D0ED Is it possible to decipher it?

Author: Sauron, 2016-05-20

2 answers

This is similar to a sha1 hash (length 40). To decipher it is the same as to pick it up randomly, it is almost impossible))

Just hope that the user has set a simple password and get the sha1 hash of all simple passwords and compare it with the original one.

I tried a couple of online decryption services, but they don't know anything about this hash)

 4
Author: jekaby, 2016-05-20 12:42:00

Not allowed.

This is not encryption, it is a hash of the built-in PASSWORD function in MySQL.

They say that in versions 5.1, 5.5 and 5.6, SHA1 is applied twice to the password string inside this function, but this detail is not available in the documentation. Here, you can check it out:

SELECT
  SHA1(UNHEX(SHA1('password'))),
  PASSWORD('password');

The documentation, however, still says that for any other purpose, except for authentication in MySQL, this function should not be used.

 6
Author: Дух сообщества, 2017-04-13 12:43:05