I lost my admin password for my SonarQube server.
To reset it I would like to execute the recommended command:
update users set crypted_password = ‘$2a$12$uCkkXmhW5ThVK8mpBvnXOOJRLd64LJeHTeCkSuB3lfaR2N0AYBaSi’, salt=null, hash_method=‘BCRYPT’ where login = ‘admin’;
But I don’t have a SQL client to do this yet.
Which SQL client should I choose and how are the steps to execute the command?
(I already tried psql but this is also asking for a password when trying to connect.)