How can I find the password from the Wordpress admin in the MySQL database and not in encrypted form? I ask for general development, I suddenly forgot the password from the Wordpress WordPress admin panel, or the customer of the services forgot this password. I know in wp_users there, but in encrypted form. How to decrypt it? or will the best solution be to put MD5 and register your new password, and the old password can no longer be discovered, what was it?

  • forgot to specify a screenshot prnt.sc/kiuybg - Mikhail Olekseevich
  • UPDATE wp_users SET user_pass = MD5('newpassword') WHERE user_login = 'username'; and do not put anything anywhere. It is impossible to decipher the password - MD5 is not reversed, but you can pick it up before the carrot begins to blink ... and who needs the old password? - Akina
  • Of course, the password is not stored in clear text. You can decipher, but this is not an option at all ... It is easier and faster to substitute a new one. Preview the salt in wp-config - Nilsan
  • one
    @Nilsan MD5 can be decrypted - this is a checksum, i.e. lossy conversion. It is impossible to decipher it, just pick it up. If only because the theoretical number of passwords (nothing in general unlimited) is greater than the number of possible MD5 sums. - Akina

1 answer 1

How can I find the password from the Wordpress admin in the MySQL database and not in encrypted form?

See - no way. The database is stored encrypted password based on blowfish .
You can change. VP will understand MD5, and after login it will replace the hash with another one.