← Back to team overview

maria-discuss team mailing list archive

Set password for all users, regardless of host value

 

Hello there.  We have scripts to restore credentials to MySQL databases from external store.  The mechanism that was in use, however, stores usernames and passwords, without consideration of the scope (host) of that auth record.  In older systems, UPDATE mysql.user SET password = PASSWORD(‘rawpassword’) WHERE user = ‘username’ worked, updating it for all values of that user that might exist in the table.

But, I’m not sure how to do this for MariaDB 10.5.  Is there way to form an “ALTER USER” statement such that it will set the password for any and all userspecs that exist with the given username?  We don’t have that many, and I could iterate the known configurations with “ALTER USER IF EXISTS”, but I worry that might miss things added in the future.

Thank you.

                        - Chris

--
Chris Ross
Software Engineering Manager – Eventing/Datastore Teams
cross2@xxxxxxxxx


Follow ups