Forget WordPress Admin Password

After setup local WordPress environment, WordPress will generate a password for admin logon. The password is so strong that forget the password can easily happen. The easiest way to get admin password back is reset it again in database.

Here is the SQL command that will do it:

UPDATE ‘wp_users’ SET ‘user_pass’ = MD5(‘PASSWORD‘) WHERE ‘user_login’ =’admin’ LIMIT 1;

Note you need update red PASSWORD to the real password you want reset.

After the command succeeds, you will be able to login to WordPress with new password.