Reset wordpress password for user from mysql

mysql -u USER -p
use database;
select id, user_login, user_pass FROM wp-users;

update wp-users set user_pass = MD5(MYNEWPASSWORD);
select id, user_login, user_pass FROM wp-users;