Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2015-04-24 22:20:07

joel
Member
Registered: 2014-07-04
Posts: 440

how can admin change hashed password from db

how can admin change hashed password from db. I want Admin to be able to change hashed password from database without needing to enter old password.

currently admin can change user email without needing to enter old email. just enter new email I click modify. I want same for user password in case de forget there password.

hashed password how to change it from admin without need to enter old pass


Warning! be informed and be forewarned. <p>
<?php
I'm not a native English Man. So my comments might contain some grammatical explosive (ELD), missapropreation of words (dinamyt), The use of wrong words (missiles), & mis spelling of words (war drones). Any of the occurrence can cause havoc. So be warned
?>

Offline

#2 2015-04-25 05:45:09

Askelon
Member
From: Bretagne − France
Registered: 2010-06-09
Posts: 202
Website

Re: how can admin change hashed password from db

Server > PhpMyAdmin?

Offline

#3 2015-05-24 14:32:32

angi1
New member
Registered: 2015-05-24
Posts: 1

Re: how can admin change hashed password from db

Askelon is right.

Offline

#4 2015-05-25 14:28:46

Sxderp
Member
Registered: 2012-11-02
Posts: 101

Re: how can admin change hashed password from db

That isn't 100% corrrect. Before you change the password field you have to add the salt and hash the new password + salt. Then take that result and plug it into the database.

I don't know what the exact process is but there should be a function somewhere for validating and / or setting a password. Send  a string through that and then change the database with the result.

Offline

#5 2015-05-28 09:32:07

chris98
Member
From: England, United Kingdom
Registered: 2013-05-31
Posts: 1,292
Website

Re: how can admin change hashed password from db

Before you change the password field you have to add the salt and hash the new password + salt.

If he's using FluxBB, there is no salt. And based on his past standard of code, I'd say the same thing. But other than that, you're right wink

Offline

#6 2016-12-24 05:02:59

rritoch
New member
Registered: 2016-12-24
Posts: 1

Re: how can admin change hashed password from db

If you are using MySQL you can use the following query to set a password.

UPDATE bb_users SET `password`=SHA1('password') WHERE username='admin'

Replace the prefix of the table name bb_ with whatever prefix you used when installing your forum. Replace password with the required password in plain text and replace admin with the username you are resetting the password for.

Offline

#7 2017-03-17 21:34:03

TigerAero
Member
From: WI, USA
Registered: 2009-02-01
Posts: 458
Website

Re: how can admin change hashed password from db

Thanks for this rritoch. It helped me just now.

Offline

Board footer

Powered by FluxBB