Forgot Username and Password

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
wagalert
Registered User
Posts: 4
Joined: Sat Apr 04, 2020 3:15 pm
Location: Sylmar
Name: George Tannous
Contact:

Forgot Username and Password

Post by wagalert »

Greetings,

I uploaded the PHPBB via godaddy.com a month ago and worked on it a little. I wanted to continue but I forgot my login. Any help will be appreciated. If login is original to admin then what will the password be?
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Forgot Username and Password

Post by KevC »

You should be able to see the username you used in the groups at the bottom of the index. There is no default username and password for the first account so it's whatever you made it.

If you have access to the database there is a way to create a new admin account and get in.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
wagalert
Registered User
Posts: 4
Joined: Sat Apr 04, 2020 3:15 pm
Location: Sylmar
Name: George Tannous
Contact:

Re: Forgot Username and Password

Post by wagalert »

Thank you KevC. Yes I have access to the database. How do I create a new admin account?
User avatar
warmweer
Jr. Extension Validator
Posts: 5823
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Forgot Username and Password

Post by warmweer »

wagalert wrote:
Sat Apr 04, 2020 3:48 pm
I uploaded the PHPBB via godaddy.com a month ago and worked on it a little.
Did you install it yourself or was this a 1-click install?
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
wagalert
Registered User
Posts: 4
Joined: Sat Apr 04, 2020 3:15 pm
Location: Sylmar
Name: George Tannous
Contact:

Re: Forgot Username and Password

Post by wagalert »

One click install
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Forgot Username and Password

Post by KevC »

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
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
wagalert
Registered User
Posts: 4
Joined: Sat Apr 04, 2020 3:15 pm
Location: Sylmar
Name: George Tannous
Contact:

Re: Forgot Username and Password

Post by wagalert »

Thank you.
User avatar
Elias
Registered User
Posts: 5136
Joined: Sat Feb 25, 2006 4:31 pm
Location: In the Water!
Name: Elias

Re: Forgot Username and Password

Post by Elias »

wagalert wrote:
Sat Apr 04, 2020 4:31 pm
One click install
If it’s still a new copy, i suggest you delete everything, download the files found here, on this site and reupload everything using a FTP program.
warmweer wrote: You could have some problems, perhaps not initially but likely when updating or upgrading. This becomes more apparent once there are extensions involved and more so with custom edits.
Thanks
"Mystery creates wonder, and wonder is the basis of man's desire to understand." - Neil Armstrong
|Installing Extensions|Writing Extensions|Extension Validation Policy|
Offering private web hosting. Contact me for details.
User avatar
ac_roma
Registered User
Posts: 318
Joined: Thu Mar 08, 2007 2:48 pm
Location: egypt,alexandria
Contact:

Re: Forgot Username and Password

Post by ac_roma »

you can delete it and install it again

or you can know it from php my admin

use md5 hash decrypt to know password

or update password by md5 generator
Post Reply

Return to “[3.3.x] Support Forum”