MySQL Forums
Forum List  »  Security

Mysql l8.0 PASSWORD() function
Posted by: Robert Boudrie
Date: October 19, 2020 08:18AM

The PASSWORD() function is gone in MySQL8.

I have a system in which user passwords are stored in PASSWORD() generated format. I would like to have these users be able to use their existing password, and be prompted to change it upon login (which would store an encrypted password in a current MySQL8 supported format and update a "password_type" enum)

How can I validate old style PASSWORD() generated hashes from within MySQL 8?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql l8.0 PASSWORD() function
820
October 19, 2020 08:18AM
447
October 19, 2020 01:41PM
498
October 29, 2020 01:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.