I'm not particularly eager to work on WordPress, but sometimes you inherit legacy code or have to support a client.
The worst thing is when you get access to the database, but nobody knows the login anymore.
So how do we go about changing the admin's password?
Pre: You must have access to the database!
Using phpMyAdmin to change the WordPress password
The first thing we need to do is log in to phpMyAdmin and find our database.
Then we need to open up the
wp_users (wp can be underscored by something unique for your install).
We need to click the
edit button on the admin record.
In the password field, add the new password in a readable way and choose
MD5 as the Function.
Please don't use passwords like this example above
Now you can click
save, and we will be able to log in with our new password!