WordPress user password change via database

Below is a quick guide on how to change the password of our WordPress user via the database.

Log in to PhpMyadmin of our database and go to the table

wp_users:

We find the user that interests us and click edit:

in the user_pass table, we change the Function to MD5 and enter our new password in the value

We set our new password, at the bottom, click Execute.