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

How to reset Admin password in SQL database?

  • I saw the password in SQL for Admin in Woedpress are encrypted. I want to reset this. How? Can someone help?

  • Answer:

    Seeing that you can see the encrypted - an md5 hash actually - I guess you can edit the password field by changing it to your own md5 hashed password. Here are the steps: 1. Go to http://www.miraclesalad.com/webtools/md5.php 2. Enter the plaintext password you would like to use when logging in as admin. 3. Submit and you should be given a long string of characters. This is the md5 hash of your password 4. Copy this and paste into the password field in phpmyadmin or sql tool you are using.

Charles Coxhead at Quora Visit the source

Was this solution helpful to you?

Other answers

Do you mean you want to remove the encryption?

Jake Harris

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.