Cybersecurity
DevOps Cloud
IT Operations Cloud
The advice and recommendations given here in the community are incorrect. First of all, updating the database user, using the select statement mentioned will fail, as the user's password is encrypted if the database has encryption in use (most enterprise-class environments should or must have encryption and/or TLS connections mandatory as well, because of security policy.
However, with that said, after logging in as another user that has the administrator role granted to it, we just tested this in DEV OO, and another user other than the admin successfully changed the admin user's password, and we logged in successfully.
Having another user outside of the admin user with this level of access is a best practice so that this type of issue could be addressed in a timely fashion and fixed.