Mysql sha256 Can you decrypt the password?

create user 'test'@'%' identified with sha256_password by 'password!';

I created the user and made it with the password sha256 password. And

select user, host, plugin, authentication_string from mysql.user;

If you look up like this,

 test| % | sha256_password | $5$KzesQl'Ds<|PBTKjN$ShZoaxo9xGd93gKg0zIq.zh51yGMyibqZlCDL0awd6

It comes out like this Can I decrypt the authentication_string value and check the password? And if I changed the password, can I check the history of the change?

mysql mariadb

2022-09-20 18:59

1 Answers

Hash algorithm is a one-way encryption method that cannot be decrypted..
The only way to decrypt is the brute-force attack.

And according to this answer, the history of the change cannot be checked because it does not support the audit column unless the https://dba.stackexchange.com/questions/77179/how-to-check-mysql-password-change-and-other-events-logs plug-in is installed separately.

2022-09-20 18:59

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656