Comments - Authentication Plugin - ed25519
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Thanks, fixed.
You cannot convert an existing password, sorry. The password hash cannot be reversed, so there is no way to restore the old password and to hash it using the new method.
Right, that makes sense. My question is more about when you already have the plaintext password. Should we just update the mysql.user table:
UPDATE mysql.user SET password = '', plugin = 'ed25519', authentication_string = ed25519_password(?) where user = ? and host = ?
And thanks for the quick fix!
Yes, that should work. Don't forget to
FLUSH PRIVILEGES
afterwards.