How do I change a password directly in the PhpBB3 SQL database?

How do I change a password directly in the PhpBB3 SQL database?

• I have inherited a PhpBB3 installation from an uncontactable previous admin who didn't leave me the password, or any mechanism to retrieve it. It runs on a MySQL database, which I have logged into with full privileges in order to change the admin password. Unfortunately, PhpBB3 apparently uses a complex multistage salted hashing technique that I'm not familiar with. Given full access to the DB, how do I generate a valid password hash to replace the old one with? I tried a simple MD5 of the known password of a normal user, and it doesn't match the DB entry. Any other way to reset the admin password via the DB is also helpful, as long as it works!

• Answer:

  run mysql and select the relevant database then use the MD5 function to set the password on the account that you want to change. For example if your phpbb3 database is called Yourphpbb3db and the users table is phpbb_users then mysql -u root -p enter your password mysql> show databases; mysql> use database Yourphpbb3db; Database changed mysql> UPDATE phpbb_users SET user_password = MD5('YourPassword') WHERE username='YourAdminName';