Previous Thread
Next Thread
Print Thread
Hop To
Query to Reset Admin Password #263019 08/07/2019 11:58 PM
Joined: Aug 2019
Posts: 2
Jennette_M Offline OP
Stranger
OP Offline
Stranger
Joined: Aug 2019
Posts: 2
Hi All:

So I have to do the proverbial "post of shame" in the sense that my special needs client Carly has just installed her licensed software in a test directory on her VPS and was messing around for awhile trying to figure out the ins and outs of UBB from being a long-time user of out internal community software at work and took about a 4-6 hours break away from it all to get dinner with myself and the rest of her support team. Come back to mess around with the test site (which will be a possible replacement for her social intranet site for her friends, family, and support personnel like me) and she forgot her admin user's password and didn't set up the email account that was tied to it on her server.

in short, is there a way from PHPMyAdmin to do a a query and reset the password?

any help in this situation would be greatly appreciated short of her just re-installing the whole thing from scratch and losing all that precious test data?

Thanks:
Jennette

Express Hosting
Re: Query to Reset Admin Password [Re: Jennette_M] #263020 08/08/2019 12:05 AM
Joined: Jun 2006
Posts: 15,851
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,851
You can edit the "USER_PASSWORD" field in the "ubbt_USERS" table, this is the hashed value of the user password; simply copy the value from a known password (from a separate account).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Query to Reset Admin Password [Re: Jennette_M] #263021 08/08/2019 1:03 AM
Joined: Jul 2006
Posts: 99
Philipp Offline
Journeyman
Offline
Journeyman
Joined: Jul 2006
Posts: 99
You can actually set a new UBB password with phpMyAdmin. Just choose the function "MD5" to generate the hash:
[Linked Image]

Re: Query to Reset Admin Password [Re: Jennette_M] #263022 08/08/2019 3:25 AM
Joined: Aug 2019
Posts: 2
Jennette_M Offline OP
Stranger
OP Offline
Stranger
Joined: Aug 2019
Posts: 2
Thanks Everyone for your quick responses and help :-) you al saved the day! issue solved!


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
visual accessibility issues.v7.7.3
by Ruben - 08/21/2019 1:50 PM
Holy grail to fix compatibility bewteen browsers
by Ruben - 08/20/2019 4:25 PM
File Manager and Image Uploads
by Ty Griffin - 08/19/2019 4:48 PM
Minimum Post Character Count
by M4TT - 08/19/2019 1:58 PM
[FIXED for 7.7.4] Strange Merge Issue
by Baldeagle - 08/16/2019 3:37 PM
Who's Online Now
1 registered members (Daryl Fawcett), 40 guests, and 281 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Photos
Stones
Amusing Terain Scenics
Sky places
Work spaces
Powered by UBB.threads™ PHP Forum Software 7.7.3