RDM - MySQL users. How to change user's password ?
Hi,
I have admin level access but I just can't find where I can change user's password. I can create, edit and delete user apparently, but not his password!
Is this by design ?
RDP version: 13.5.0
Thank you
2017-11-30 15_02_10-Remote Desktop Manager.png
All Comments (2)
Hi,
This is only implemented in the console for SQL Server. I can add a feature request if you want.
Regards
David Hervieux
Yes please.
I think it makes sense, especially for administrators who dont have access to a database backend...
Thank you
Update
Just tried to reset creds via MySQL Workbench, but can't find right table for this. Look like Userinfo, but then all entries for all users are empty.
Also, I need to generate a password hash, which algorithm sha1, sha2 ? A bit messy to be honest with you.
Update 04/12/2017
Apparently RDM schema does not contain user information and stored in mysql.user itself.