How to Reset Your Password for WordPress in MySQL

1. Log-in to phpMyAdmin through your hosting provider's control panel.
2. Open your WordPress installation's database. If you cannot remember which database you used, you can use an FTP program to open the site's wp_config.php file to find the name.

3. Browse through the 'wp_users' table. The prefix may be different, depending upon how you set-up your installation. The wp_config.php file can also tell you what the prefix is.
4. Generate a MD5 password. You can do this with a number of free websites, such as the site in the Resources section. Enter the password you want to use in the form and the site will provide a MD5 string.
5. Replace the administrator password. Select 'edit' next to the field for the administrative log-in and enter the MD5 string from Step 4 in the 'user_pass' field. Save your changes.
6. Log into your WordPress administrative panel using the password that you selected in Step 4, along with the administrative username.