How to Reset a Wordpress Password

If you have forgotten your wordpress credentials, or possibly have had your wordpress install compromised; you may find yourself needing to change your admin username and/or password to regain access to your site.

Reset a User's password through MySQL

• Log in to your wordpress database using MySQL's command line interface
• Find the ID of the user's password you want to change

SELECT ID, user_login, user_pass FROM wp_users;

• Change that user's password to a new one

UPDATE wp_users SET user_pass=MD5('newstrongpassword') WHERE ID = usersID;

Reset a User's Password through phpMyAdmin

If you have Plesk or cPanel, phpmyadmin should be included by default. Open it up for the domain and database that your wordpress site belongs on. If you don't remember the database name, look in your wp-config.php for a line similar to this:

define('DB_NAME', 'wordpress_blog');

In this example, "wordpress_blog" is the name of the database.

• Once you're logged in to phpmyadmin, click on the wp_users table.
• Make sure you are on the browse screen
• Find the username you want to change the password for
• Click edit on that username
• Enter in your new password in the Value field of the user_pass line
• Select "MD5" from the dropdown under the Functions column for the user_pass line
• Click Go at the bottom of the screen, and then you should be able to log in with the new password