Force admin password

[PiotrGT]

My VPS is unable to send emails therefore i cannot change my password and because of this im unable to access the admin panel. This is going to be my first login after the vb4 upgrade.

Is there a way to force a password via phpmyadmin or any other way to get myself into the admin panel?

[Lynne]

What is your userid? You can run a query like this:

UPDATE user AS user 
SET token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy' 
WHERE userid = xxx;

The above will reset the password to pass1234. Change the xxxxx to your userid (usually 1).

If you have a database prefix, then add that in front of the first "user" table name.

[PiotrGT]

Okay we did this and we are still unable to login - the request did process through phpmyadmin.

Error:
You have entered an invalid username or password. Please enter the correct details and try again. Don't forget that the password is case sensitive. Forgotten your password? Click here!

You have used 2 out of 5 login attempts. After all 5 have been used, you will be unable to login for 15 minutes.

Is there another way?

[Lynne]

Did you change your domain (and perhaps your cookies are set incorrectly)?

And wait a sec.... you are posting in the vB5 section, so I gave you the vb5 query.

If you really mean vB4, and not vB5, then use this query to change the password:

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.

[PiotrGT]

Thanks Lynne! It's fine now - my friend took care of this. I'm just his translator
We are almost done with the phpbb3 to vb4 to vb5 migration.
Now we just need to get the mail server going and sort out the issue with attachments - the images that are inline just show some BBcode like code and there is a list of all images in the attachment list (all images load once clicked on) - i already started a thread on this.