Reset Wordpress password via SQL?

Question

How would I go about changing a Wordpress user's password directly in the database? I notice it's not just an md5'd password. There is a $P$B at the start

Thanks,

Answer 1

I did it like this:

UPDATE wp_users SET user_pass= MD5('enter-your-new-password-here') WHERE ID = 1;

Note: you may need to change the ID of your user.

Then, you can check it:

 SELECT * FROM wp_users;

Right now, the password won't have the WordPress format, but WordPress will understand it as MD5, and it all works great!