XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Urgent - resetting admin pass
Register
1
aharon
Urgent - resetting admin pass

  • 2009/7/9 11:54

  • aharon

  • Not too shy to talk

  • Posts: 172

  • Since: 2004/9/17


Hi,

Am trying to reset admin pass, can anyone tell me if doing something like:
INSERT INTO `xoops_users` (`Rows`, `pass`) VALUES
(1, 'admin_pass_goes_here');

Should help or not..?

Many thanks!

Aharon
2
ghia
Re: Urgent - resetting admin pass

  • 2009/7/9 12:17

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


No, that won't work for several reasons.
Register yourself again as user.
Copy in phpMyAdmin the password field (it's encoded) from this user to the one of uid 1.
Login as admin with the password used in the registration.
3
aharon
Re: Urgent - resetting admin pass

  • 2009/7/9 12:31

  • aharon

  • Not too shy to talk

  • Posts: 172

  • Since: 2004/9/17


cool! Thanks ghia!
4
go4group
Re: Urgent - resetting admin pass

  • 2009/7/22 19:26

  • go4group

  • Just popping in

  • Posts: 2

  • Since: 2008/11/10


Admin password is stored as MD5 of the password so you need to run query like

update `xoops_users` set pass=MD5('admin_pass_goes_here') were uname = 'admin';

update `xoops_users` set pass=MD5('admin_pass_goes_here') were uname = 'admin';

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

430 user(s) are online (292 user(s) are browsing Support Forums)

Members: 0

Guests: 430

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits