First enter mysql and search for the user:

use DATABASE;
select * from wp_users;

After getting the user’s id, just run:

UPDATE wp_users SET user_pass = MD5('new_password') WHERE id = 1;

And you should be good to go.