0

I'm using the mysql 8.0.15. i know there is one same question, but in the recent version mysql 8.0.11, PASSWORD function is removed. I'm trying to get back my root user password, i have got the encrypted string caching_sha2_passIBjIZxTzot5bM9bujMxG9orfl6Ctt.w2SDLZUzAsrxD0 how can i decrpyt it? Also i try to follow solutions from this to reset password, but without the password function, almost cannot proceed.

chancyWu
  • 14,073
  • 11
  • 62
  • 81
  • 1
    You can't. It's not encrypted. It's been hashed and salted - there is no way to recover the original text. Use some recovery options and boot mysqld into safe mode. – Matt Clark Apr 01 '19 at 02:06
  • @MattClark yes, i boot the mysqld into safe mode and try to run sql like `update mysql.user set authentication_string=password('none') where user='root';' but the password is removed. not quite sure even update the password, still can be uncompressed. – chancyWu Apr 01 '19 at 02:10

1 Answers1

0

Passwords for authentication are stored in a way that's irrecoverable, it's a one-way hashing function that's applied. In this case it's SHA2.

There's no way to "unhash" this by design. The database entry contains just enough information to validate any given password, but not enough to tell you what the password is.

You can reset the password by disabling password checks and set a new password.

tadman
  • 208,517
  • 23
  • 234
  • 262