Brinkster Knowledge Base
I lost my wordpress password
This will reset the password to password. "5f4dcc3b5aa765d61d8327deb882cf99" is the md5 hash version of "password"
update wp_users set user_pass='5f4dcc3b5aa765d61d8327deb882cf99' where user_login='admin'
If you do not know the name of the user you need to reset, run this next query in the Brinkster database manager to list all of the users that are in your Wordpress blog.
select user_login from wp_users
Find the user you want to edit and replace admin with the name of the user you want to update from the query above.