How can I set a new password for a user in a table through the MySQL database?

Question

MySQL

There was a problem with authorization. We use the Codeignator framework, mysql. Password reset email not received. We decided to change the password through the database. As far as I understand, the password is set there a little differently, namely, you just can’t enter the password, you need to do it in a different transcription.
Can you tell me how can I set a new password for the user through the database?

Answer 1

You create a new test user with the desired password. Then in phpMyAdmin you take the salt and hash of the password and replace them with the fields of the user who needs to change the password. And you delete this temporary user.

Answer 2

As an option: see how php implements the encryption algorithm, most likely md5 and something else, or just md5,
then generate your password, write down its code in the database and that's all business-)