MySQL Forums
Forum List  »  General

Re: Hash password for mysql above 5.7.6
Posted by: Georgi Kodinov
Date: August 31, 2015 01:21AM

The opaquenes arises from the weird pre-5.7.6 architectural concept that one can calculate the hash of a password without prior knowledge of the authentication method (=plugin) used.

This resulted in even uglier workarounds (@@old_passwords). But usability was not the onlu problem of the pre-5.7.6 approach. The plugins were not getting the chance to generate and verify the hashes. It was all hard coded by plugin name and only few (well, 2, native and sh256) could even work with passwords properly.

I know the change sounds abrupt and is certainly not 100% backward compatible, but it was the layers of workarounds that got us to where we were.
So I hope you'll endure through the inconveniences for the sake of more powerful and extendable authentication support.

Options: ReplyQuote


Subject
Written By
Posted
Re: Hash password for mysql above 5.7.6
August 31, 2015 01:21AM


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.