Comments - Authentication Plugin - ed25519

6 years ago Dave Welsh

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '% IDENTIFIED VIA ed25519 USING 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY'' at line 1

You need to surround the percent sign with single quotes:


Also, can we get instructions for converting an existing user's password to using new hash?

6 years ago Sergei Golubchik

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.

6 years ago Dave Welsh

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!

6 years ago Sergei Golubchik

Yes, that should work. Don't forget to FLUSH PRIVILEGES afterwards.

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.