Link to home
Create AccountLog in
Avatar of gospelgeezer
gospelgeezer

asked on

Lost admin password for phpBB forum

I created a website using Joomla and some time ago someone helped me install phpBB so I could create a forum in the future. This was about a year and a half ago now and unfortunately I have forgotten the password for admin access to the forum. I have tried logging into the site using my Joomla admin password but this does not give me access to phpBB admin panel.

I am guessing that I can find the password somewhere in a database (i.e. using phpMyadmin in my cPanel). However, I am somewhat of a novice with web development and cannot find the information I need in the database.

If someone can tell me exactly where I can find the password or how to reset a new one I would be very grateful.
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

You may not be able to recover the password.  In most installations, the password is not stored in clear text; instead a md5() or similar encrypted version is stored.  This prevents exposing all the passwords if a hacker or insider somehow gets a copy of your data base.  Sorry to say, this is easier than you think.

I would delete the current installation and start over with a completely new installation of the scripts (at the current revision levels).  If you have important information in your forum data base, you might want to hire a professional developer to help you get it right.

Sorry there is no magic bullet that I know of, ~Ray
Avatar of Hagay Mandel
Ray_Paseur is right!
The maximum you can achieve is exporting the forum content tables, reinstalling the forum module, and importing these tables content to your new installation.
SOLUTION
Avatar of shaunak
shaunak

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gospelgeezer
gospelgeezer

ASKER

Thanks for everyone's comments.

I have followed the advice of rsultan and shaunak.

However, I still cannot access the admin panel for my phpBB forum. I have successfully changed the password in phpMyadmin but this user will not give me access to phpBB admin panel. Therefore, it cannot be the same admin user that was originally set up for phpBB

Having further investigated my problem, I think I must have accidentally deleted the original phpBB admin user several months ago. I probably did this in Joomla as I have a bridge installed (Blogomunity p8pBB) and if I delete a user in the Joomla User Manager it automatically deletes in phpBB database.

With this in mind, I now need to ascribe phpBB admin access to the appropriate user in the phpbb_users table. Is this possible and if so how do I do it?

Many Thanks
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account