To reset the password for wordpress all you need to do is the following:
1) Upload to your hosting phpminadmin. This is a simple script that allows you to run a database query on your site allowing you to reset your password. You can download it from http://phpminiadmin.sourceforge.net/
2) You need to get database logins for your wordpress database. You can find them by viewing wp-config.php file. Values that are needed are in the following area:
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘database-name-here‘);
/** MySQL database username */
define(‘DB_USER’, ‘database-user-here‘);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘database-user-password-here‘);
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
3) Open the phpminiadmin file and update the values there in the following locations:
‘user’=>”database-user-here“,#required
‘pwd’=>”database-user-password-here“, #required
‘db’=>”database-name-here“, #default DB, optional
‘host’=>””,#optional
4) Upload phpminiadmin file to where you have your wordpress site is running.
5) Run the script and load the table called “wp_users”. Run the following query when you view the table:
UPDATE wp_users SET user_email= “youremail@yourdomain.com” WHERE user_login=”admin”
6) Now go to the login page on wordpress and click on “Lost your password?”. Put in your email address or user name. WordPress will send you a link to reset the password and you will be back in business.
