13 Mar, 2010

WordPress: Resetting admin password from SQL

Posted by: admin In: Mysql|Wordpress

You could call checkmate of the forgetful, i mean not remember your blog administrator password. This happens  when creating new blog, or after a long time of inactivity. Before performing this procedure, which is irreversible, we recommend you use the special page designed by the creators of WordPress (just add the URL of your domain the following syntax /wp-login.php? Action=lostpassword)

So if you have not yet resolved, proceed with the “heavy weapons”  using phpMyAdmin Will change via an SQL the administrator password. Once in phpMyAdmin, press the button SQL  in the top left, under the logo of the program. Now you can write this command in the appropriate box

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

Obviously your new password is .. PASSWORD, and of course we recommend you change immeditely at  first access the administrative area of the blog.

No Responses to "WordPress: Resetting admin password from SQL"

Comment Form