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';