Forgot Username and Password

[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?

[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.

[wagalert]

Thank you KevC. Yes I have access to the database. How do I create a new admin account?

[warmweer]

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?

[wagalert]

One click install

[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', '[email protected]', '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

[wagalert]

Thank you.

[Elias]

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.

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

[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