Reset passwords in WordPress Database

Forgotten a user password, but still got access to the WordPress database?

If so then you can use the following SQL to quickly and easily change the password:

update XXXX_users
set user_pass = md5(‘admin’)
where user_login = ‘admin’

(amend XXXX_ to your database prefix, username on this example is admin as will be the password)
Don’t forget it this time!