Forums

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
?>

Askelon

Member

From: Bretagne − France

Registered: 2010-06-09

Posts: 202

Website

Re: how can admin change hashed password from db

Server > PhpMyAdmin?

angi1

New member

Registered: 2015-05-24

Posts: 1

Re: how can admin change hashed password from db

Askelon is right.

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.

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

---

Download Aura - Illuminate Your Community.
Why should I use Aura? | Aura demo | Convert to Aura

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.

TigerAero

Member

From: Northwoods, WI, USA, Earth

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.

---

The Tiger Tribe Door