Reset password for wordpress-user

If you have forgot your password for your wordpress-instance, but you have access to the database you can set a new password!

# mysql -u <database> -p
> use <database>
> SELECT ID, user_login, user_pass FROM wp_users;
> update wp_users set user_pass = MD5('yourPassword') where ID = <userid>;

source: [Link]