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.
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:
CREATE USER safe@'%' IDENTIFIED VIA ed25519 USING 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY';
Also, can we get instructions for converting an existing user's password to using new hash?
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 PRIVILEGESafterwards.