WordPress: Changing a user password via database Print

If you lose the password for your WordPress Admin user, you can enter a new one quickly in the database using phpMyAdmin.  After logging in to cPanel, follow these quick steps:

1. Click phpMyAdmin.
2. Click the "+" next to your WordPress database.  WordPress databases usually begin with "wp_".
3. Click "wp_users".
4. Click "Edit" next to your administrative login.
5. Enter a new password in the "user_pass" field.
6. Click the drop-down menu next to your new password and select "MD5" from the list.
7. Click "Go"