Jump to content
Froxlor Forum
  • 0

How can I change the password by using Mysql?


pauls52
 Share

Question

Hello Froxlor Forum

I am a total newbie when it comes to Froxlor but after a lot of trial and error I managed to get it installed and working. However when I logged out of my last session I cannot log in and the email reset is disabled. I am running it on VPS with Ubuntu Server 20.4..

I tried to replace the password with the generic "password" using the command lines suggested by the user doop but it didn't work.  I tried this

UPDATE 'panel_admins' SET 'password' = '0040f2abc2cff0c8f59883b99ae9fab6' WHERE 'panel_admins'.'loginname' = 'Admin';This will set the password to 'Password!' for the admin username.

Am I missing something? Do I need to replace that long string of numbers and letters with the one from my table? or is there a way to turn on email rest from Mysql and get it to send me a new password?

If this doesn't work is there a way to wipe the password and insert another user with ssh and the terminal?

Thanks

Paul

 

Edited by pauls52
Spelling a name wrong.
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Reset password for admin using mysql (change values accordingly):

UPDATE panel_admins SET `password` = md5('thepassword-youwant') WHERE `loginname` = 'admin';

Activate "password reset function for admin" using mysql:

UPDATE panel_settings SET `value` = '1' WHERE `varname` = 'allow_preset';
UPDATE panel_settings SET `value` = '1' WHERE `varname` = 'allow_preset_admin';

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share



×
×
  • Create New...