Problem with WordPress admin-login? or Forgot your WordPress admin password?
Reset your local wordpress password easily
While building my theme I installed wordpress with lots of sample data and I realized.
mysql picture
I forgot my password and couldn't recover it even with a "forgot password" link. So after
playing around for 30 mins, I reset my password. This is how.
Wordpress admin login error happen for two following reason:
- User may forgot the admin password
- User might have entered wrong site url in setting tab
go to your mysql administrator (usually called as phpmyadmin)
- select your wordpress database
- run the following update query with your password as in bracket using sql tab
SELECT 'wordpress' //this should be your database name
UPDATE `wp_users` SET `user_pass` = MD5( 'password' ) WHERE `ID` =1 LIMIT 1 ;
where password is your new password. Your password is reset, for the admin acount.
For admin side login problem, there might be another reason. You might have given wrong site
url. This can be update by the following query
UPDATE `wp_options` SET `option_value` = 'You site url' WHERE `wp_options`.`option_id` =1
LIMIT 1 ;
It will update your site url in the wp_options table and it will solve your login error.