Question:
I’m unable to get into my ExpressionEngine backend, and I’m not receiving my password reset email. Can I edit my password via PHPMyAdmin?
Answer:
You can, but you need to keep in mind that your password is not stored as ascii text, but as a SHA1 encrypted password. However, you can use the following code which is for the password called “password”:
5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8
You find the SHA1 encrypted password in the “exp_members” table from your ExpressionEngine database