Regaining access to forum, please help..

[shibby2]

Hey everyone, I have an old 'test' forum that I haven't used in about 3 years. I really need to gain access to it, but for some reason none of my passwords are working.

I've tried requesting a new password, but I never get an email, for whatever reason. I tried registering a new account so I could use tools.php, but registrations are disabled.

Is there any other way for me to gain access again? I'm all out of ideas.

Please help, I'm desperate!

[Max Taxable]

You have file access?

[Dragonsys]

can you access the DB? if so, blank out your password

[shibby2]

Yes I have FTP access and database access via phpmyadmin.

What will removing the password encryption in the database do?

[RichieBoy67]

That wont work..

Why dont you just register a new user, than go into the usertable and change it to an admin..Change the userid in your config and bam..your in.

Think you can use this too:

https://hashkiller.co.uk/md5-decrypter.aspx

[shibby2]

Can't register a new user, because new registrations are turned off.

Is there any way I can turn on registrations via phpmyadmin? And, if I'm able to do that, would I be able to turn off 'email verification' for registrations in phpmyadmin also?

Oh yea, also, is the forums main email listed somewhere in the database? I'd like to know which email I used, so I can see why it's not sending any emails out.

[Lynne]

If you cannot register a new account and have absolutely no access to any other accounts, the final option is a database query.

MAKE A FULL DATABASE BACKUP BEFORE YOU MANUALLY EDIT THE DATABASE. VERIFY IT AS WELL.

Open the database in a tool like phpmyadmin.

Run the Query:

UPDATE user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above will reset the password of user with userid = 1 to pass1234. Change the userid if your Admin account is not userid 1.

*NOTE* - If you have a table prefix setup in your config.php file then you must put the table prefix in front of the first "user" on the first line.

Example:

UPDATE vb_user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above query is if vb_ is the table prefix.

You should be able to tell easily if there is a prefix if all the table names start with the same few characters.

Once the query is run the password will now be pass1234 or whatever you set.

(The above is NOT valid for 5.1.10 and up.)

[shibby2]

Thanks Lynne, I'll give it a try!

--------------- Added [DATE]1454011190[/DATE] at [TIME]1454011190[/TIME] ---------------

Just to verify, where exactly do I paste that query? I'm not too great with databases.. I have a few different databases in my account, so I don't want to put it in the wrong place and risk screwing the others up.

Thanks again!


Nevermind, figured it out.. it worked!

Thank you sooooo much!

[Lynne]

Glad you got it working.