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_usersset pass=MD5('admin_pass_goes_here'were uname 'admin';

Login

Who's Online

166 user(s) are online (44 user(s) are browsing Support Forums)


Members: 0


Guests: 166


more...

Donat-O-Meter

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

Latest GitHub Commits