You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#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
Download Aura - Illuminate Your Community.
Why should I use Aura? | Aura demo | Convert to Aura
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: 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.
Offline
Pages: 1