Lost Admin Password

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Lost Admin Password

Post by firebuff55123 » Sat Sep 09, 2017 12:25 am

I have lost my admin password. I cannot remember it. Is there a way to get a temp
password sd=o I can reset it?

firebuff55123
Last edited by JimA on Sat Sep 09, 2017 8:37 am, edited 1 time in total.
Reason: Moved from phpBB Discussion to 3.2 Support Forum

User avatar
3Di
Registered User
Posts: 11699
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Lost Admin Password

Post by 3Di » Sat Sep 09, 2017 12:45 am

This script is for 3.1/3.2, instructions are there - at a first glance.
https://gist.github.com/3D-I/416f0298bf ... f7ddbfad0c
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Re: Lost Admin Password

Post by firebuff55123 » Sat Sep 09, 2017 8:20 am

I am sorry but all this script returns is:
Casnnot log in as a different usertan a admin usert

I cannot still login as administrator.

firtebuff55123

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7004
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Lost Admin Password

Post by JimA » Sat Sep 09, 2017 8:36 am

In phpMyAdmin, run the following, which will create an admin user named Admin1 with a password of admin. From that point you should be able to get into the ACP.

Code: Select all

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not phpbb_

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running database queries.

As soon as you have done this, use the temporary admin account to change the details on the original admin account, then delete the temporary account.
This is because:
  1. anyone could use that account to log in to your board if you didn’t change the password.
  2. this temporary user has not been fully set up (e.g. it is not a member of the “Registered users” group, so it won’t have normal access to your forums).
To remove the account you will first need to remove “founder” status from it: ACP > USERS AND GROUPS tab > Manage Users > Admin1 > Overview > Founder = No
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

User avatar
3Di
Registered User
Posts: 11699
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Lost Admin Password

Post by 3Di » Sat Sep 09, 2017 6:01 pm

Jim, that's exactly what the Script does already. Not sure what's the OP's issue here.
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Re: Lost Admin Password

Post by firebuff55123 » Sat Sep 09, 2017 11:24 pm

So change the prefix of all the phpbb tables in the database?

Or alter the code of the script to feflect the different phpbb table names?

firebuff55123

User avatar
3Di
Registered User
Posts: 11699
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Lost Admin Password

Post by 3Di » Sat Sep 09, 2017 11:55 pm

firebuff55123 wrote:
Sat Sep 09, 2017 11:24 pm
So change the prefix of all the phpbb tables in the database?

Or alter the code of the script to feflect the different phpbb table names?

firebuff55123
You don't need to alter my code, it already takes care of any DB supported by phpBB itself. ;).
I believe you didn't get the concept of it, the script creates a new founder with which you can amend your original account. etc..
will create an admin user named Admin1 with a password of admin
You must use it, not your credentials.
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Re: Lost Admin Password

Post by firebuff55123 » Thu Sep 14, 2017 1:55 am

I am, sorry but I cant this script to work...


General Error
SQL ERROR [ mysql4 ]

Field 'user_occ' doesn't have a default value [1364]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

firebuff55123

User avatar
3Di
Registered User
Posts: 11699
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Lost Admin Password

Post by 3Di » Thu Sep 14, 2017 5:01 am

Seems like you have a 3.0.x board, if so you should use this one instead:
https://gist.github.com/3D-I/599acb267e ... 4a5dbe1f4a
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Re: Lost Admin Password

Post by firebuff55123 » Thu Sep 14, 2017 9:25 am

Now I get thjis error,,., please help me!

General Error
SQL ERROR [ mysql4 ]

Duplicate entry 'admin1' for key 'username_clean' [1062]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 47782
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Lost Admin Password

Post by stevemaury » Thu Sep 14, 2017 2:40 pm

Have you tried clicking the "I forgot my password" link on the login page?
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

firebuff55123
Registered User
Posts: 22
Joined: Wed Oct 16, 2013 1:14 am

Re: Lost Admin Password

Post by firebuff55123 » Thu Sep 14, 2017 10:46 pm

That is for the login account not the Admin account.. I wish the was such a
button on the login account

I need a proceedural list of all the steps requiored to reset the passwordf.
I am a 71 year old man with a stroke and a heart attack. Sush proceeedures are no
no longer easy for me.

firebufdf55123

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 47782
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Lost Admin Password

Post by stevemaury » Fri Sep 15, 2017 12:14 am

The Admin account IS a login account. Put that username in the login box and click the I forgot password link. You need to know the email address of the Admin account (the one you provided at installation).
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: DB3, Majestic-12 [Bot], onomoney and 20 guests