Fixing the Login problem of Administrator user account

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
POURYA.RAOUFI
Registered User
Posts: 9
Joined: Fri Jun 02, 2023 5:21 am
Name: Pourya Raoufi
Contact:

Fixing the Login problem of Administrator user account

Post by POURYA.RAOUFI »

When logging in with the Username and Password of the Administrator user account, it is not possible to Login to the system.

Even by entering CAPTCHA, it is not possible to Login to the system.

I encounter this error.

Code: Select all

You exceeded the maximum allowed number of login attempts. In addition to your username and password you now also have to pass the CAPTCHA test.
I am looking forward to hearing from you soon.
Thank you in advance for invaluable co-operation.
Last edited by Mick on Sat Jun 03, 2023 8:56 am, edited 1 time in total.
Reason: Solved.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26505
Joined: Fri Aug 29, 2008 9:49 am

Re: Fixing the Login problem of Administrator user account

Post by Mick »

Welcome to phpBB

You can try this:

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
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
POURYA.RAOUFI
Registered User
Posts: 9
Joined: Fri Jun 02, 2023 5:21 am
Name: Pourya Raoufi
Contact:

Re: Fixing the Login problem of Administrator user account

Post by POURYA.RAOUFI »

Thanking you for your kind co-operation.
With my best wishes of success and prosperity.
Post Reply

Return to “[3.3.x] Support Forum”