Lost User Password - how to reset

Implemented

Lost User Password - how to reset

avatar

Hi there,

a user lost it's password for logging in to our rdm.
We use mariadb as database backend and we use database encryption with shared key.
Can the rdm admin reset the user password?
Or can we reset the password directly in the sql user table?


Thank you

Best Regards
Jonas

All Comments (5)

avatar

Hello,
You need to reset it from the database backend directly. Sorry about that.

Regards

David Hervieux

avatar

I've added a to-do to add this functionality in the MySQL/MariaDB data sources.

Stéfane Lavergne

avatar










Can I just use my mysql editor to do this?
Is this safe? Don't want to destroy the user data or encryption.

Best Regards
Jonas

avatar

Hello,

You should be able to accomplish this via HeidiSQL
https://www.heidisql.com/download.php

Inside this application, go in Tools -> User Manager to manage your users.

Best regards,

Jeff Dagenais

avatar

Ok,
thank you, it worked.

Best Regards
Jonas