INSERT INTO user_roles(uuid, user_uuid, role)
(select uuid from users where login=‘mylogin’),
As well as
update users set crypted_password=‘100000$t2h8AtNs1AlCHuLobDjHQTn9XppwTIx88UjqUm4s8RsfTuXQHSd/fpFexAnewwPsO6jGFQUv/24DnO55hY6Xew==’, salt=‘k9x9eN127/3e/hf38iNiKwVfaVk=’, hash_method=‘PBKDF2’, reset_password=‘true’, user_local=‘true’ where login=‘admin’;
Still i am not able to reset the admin password, let me correct if iam doing anything not conventional to sonar doc.
You’re supposed to sub-in your login, where it says 'mylogin'. That grants your account admin permissions and from there you should be able to do what you need to do via the UI - including re-instating the admin account (just re-add it) and then resetting its password.
The second query resets the admin account’s password to admin, but that’s not going to do any good if the account has been deactivated and not re-established yet.