Brand new Maintain Newest Password and Dispose of Old Code clauses implement dual-password functionality and therefore are offered since MySQL 8

Brand new Maintain Newest Password and Dispose of Old Code clauses implement dual-password functionality and therefore are offered since MySQL 8

The condition must be considering in the event the password alter toward are needed to identify the modern code, given that confirmation that the affiliate attempting to make the alteration indeed knows the modern code.

The declaration goes wrong in the event your clause is offered but does not match the latest password, even when the clause is actually optional.

Sets this new membership verification plug-in to auth_plugin , seats the cleartext ‘ auth_sequence ‘ well worth toward plugin having you are able to hashing, and stores the effect in the account row on the mysql

Preserve Latest Password holds a merchant account current password as the additional code, replacing any current supplementary password. The brand new code becomes the key password, however, readers may use the latest membership to connect to this new server having fun with possibly an important otherwise additional password. (Exception: If for example the the fresh password specified of the Alter Member declaration was empty, the secondary password will get empty as well, regardless of if Maintain Current Password is provided.)

(more…)

Continue ReadingBrand new Maintain Newest Password and Dispose of Old Code clauses implement dual-password functionality and therefore are offered since MySQL 8