To change user password in WordPress using MySql you can use the following query.
Sample MySql
UPDATE wp_users SET user_pass = MD5('NewPassword') WHERE user_login = 'UserName';
To change user password in WordPress using MySql you can use the following query.
UPDATE wp_users SET user_pass = MD5('NewPassword') WHERE user_login = 'UserName';