{"id":1473,"date":"2012-02-21T05:59:11","date_gmt":"2012-02-21T05:59:11","guid":{"rendered":"http:\/\/www.webputzer.com\/?p=1473"},"modified":"2013-12-05T15:09:00","modified_gmt":"2013-12-05T15:09:00","slug":"reset-wordpress-password","status":"publish","type":"post","link":"http:\/\/www.webputzer.com\/?p=1473","title":{"rendered":"Reset WordPress Password"},"content":{"rendered":"<p>\u00a0In WordPress, there is more than one way to set your password. In normal circumstances, you can do it through the WordPress interface. If you forget your password, WordPress has a built in recovery mechanism that uses email.<\/p>\n<div id=\"pagebody\">\n<div>\n<div id=\"bodyContent\">\n<p>But on some hosts, especially when email isn&#8217;t working right, sometimes you have to take different steps to reset your password.<\/p>\n<p>Here&#8217;s a list of different ways to reset a password. Any one of them will work, and you only need one to succeed. Which method you will use depends on what type of access you still have to your website.<\/p>\n<h2>To Change Your Password<\/h2>\n<p>To change your password in current versions:<\/p>\n<ol>\n<li>In the Admin Panel menu, go to USERS<\/li>\n<li>Click on your username in the list to edit<\/li>\n<li>In the Edit User screen, scroll down to the New Password section and type in a new password in the two boxes provided. The strength box will show how good (strong) your password is.<\/li>\n<li>Click the UPDATE PROFILE button<\/li>\n<\/ol>\n<dl>\n<dd>Your new password takes effect immediately.<\/dd>\n<\/dl>\n<p><a id=\"Through_the_automatic_emailer\" name=\"Through_the_automatic_emailer\"><\/a><\/p>\n<h2>Through the automatic emailer<\/h2>\n<p>If you know your username and the email account in your profile, you can use the &#8220;lost password&#8221; feature of WordPress.<\/p>\n<ul>\n<li>Go to your WordPress Login page (something like <a title=\"http:\/\/codex.wordpress.org\/Resetting_your_password\" href=\"http:\/\/codex.wordpress.org\/Resetting_your_password\">http:\/\/yoursite.com\/wordpress\/wp-login.php<\/a>)<\/li>\n<li>Click on lost password<\/li>\n<li>You will be taken to a page to put in some details. Enter your user name and the email address on file for that account.<\/li>\n<li>Wait happily as your new password is emailed to you.<\/li>\n<li>Once you get your new password, login and change it to something you can <em>remember<\/em> on your profile page.<\/li>\n<\/ul>\n<p><a id=\"Through_MySQL_Command_Line\" name=\"Through_MySQL_Command_Line\"><\/a><\/p>\n<h2>Through MySQL Command Line<\/h2>\n<ol>\n<li>Get an MD5 hash of your password.\n<ul>\n<li><a title=\"http:\/\/www.miraclesalad.com\/webtools\/md5.php\" href=\"http:\/\/www.miraclesalad.com\/webtools\/md5.php\">Visit md5 Hash Generator<\/a>, or&#8230;<\/li>\n<li>Create a key with Python. or&#8230;<\/li>\n<li>On Unix\/Linux:\n<ol>\n<li>Create file wp.txt with the new password in it (and *nothing* else)<\/li>\n<li><tt>md5sum wp.txt<\/tt><\/li>\n<li><tt>rm wp.txt<\/tt><\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<\/li>\n<li>&#8220;<tt>mysql -u root -p<\/tt>&#8221; (log in to MySQL)<\/li>\n<li>enter your mysql password<\/li>\n<li>&#8220;<tt>use (name-of-database)<\/tt>&#8221; (select WordPress database)<\/li>\n<li>&#8220;<tt>show tables;<\/tt>&#8221; (you&#8217;re looking for a table name with &#8220;<tt>users<\/tt>&#8221; at the end)<\/li>\n<li>&#8220;<tt>SELECT ID, user_login, user_pass FROM (name-of-table-you-found)<\/tt>&#8221; (this gives you an idea of what&#8217;s going on inside)<\/li>\n<li>&#8220;<tt>UPDATE (name-of-table-you-found) SET user_pass=\"(MD5-string-you-made)\" WHERE ID = (id#-of-account-you-are-reseting-password-for)<\/tt>&#8221; (actually changes the password)<\/li>\n<li>&#8220;<tt>SELECT ID, user_login, user_pass FROM (name-of-table-you-found)<\/tt>&#8221; (confirm that it was changed)<\/li>\n<li>(type Control-D, to exit mysql client)<\/li>\n<\/ol>\n<p>Note if you have a recent version of MySQL (version 5.x?) you can have MySQL compute the MD5 hash for you.<\/p>\n<ol>\n<li>Skip step 1. above.<\/li>\n<li>Do the following for step 7. instead.\n<ul>\n<li>&#8220;<tt>UPDATE (name-of-table-you-found) SET user_pass = MD5('\"(new-password)\"') WHERE ID = (id#-of-account-you-are-reseting-password-for)<\/tt>&#8221; (actually changes the password)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><a id=\"Through_phpMyAdmin\" name=\"Through_phpMyAdmin\"><\/a><\/p>\n<h2>Through phpMyAdmin<\/h2>\n<p>This article is for those who have <a title=\"phpMyAdmin\" href=\"http:\/\/codex.wordpress.org\/phpMyAdmin\">phpMyAdmin<\/a> access to their database. <strong>Note: use phpMyAdmin at your own risk. If you doubt your ability to use it, seek further advice. WordPress is not responsible for loss of data.<\/strong><\/p>\n<p>Begin by logging into phpMyAdmin and click <strong>databases<\/strong>.<\/p>\n<div>\n<div>\n<div>\n<div><a title=\"Image #2\" href=\"http:\/\/codex.wordpress.org\/File:changepw2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/images\/thumb\/9\/92\/changepw2.jpg\/180px-changepw2.jpg\" alt=\"\" width=\"180\" height=\"160\" border=\"0\" \/><\/a><\/p>\n<div>\n<div><a title=\"Enlarge\" href=\"http:\/\/codex.wordpress.org\/File:changepw2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/skins\/common\/images\/magnify-clip.png\" alt=\"\" width=\"15\" height=\"11\" \/><\/a><\/div>\n<p>Image #2<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<ul>\n<li>A list of databases will appear. Click your WordPress database.<\/li>\n<\/ul>\n<\/div>\n<div>\n<div>\n<div>\n<div><a title=\"Image #3\" href=\"http:\/\/codex.wordpress.org\/File:changepw3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/images\/thumb\/3\/32\/changepw3.jpg\/180px-changepw3.jpg\" alt=\"\" width=\"180\" height=\"119\" border=\"0\" \/><\/a><\/p>\n<div>\n<div><a title=\"Enlarge\" href=\"http:\/\/codex.wordpress.org\/File:changepw3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/skins\/common\/images\/magnify-clip.png\" alt=\"\" width=\"15\" height=\"11\" \/><\/a><\/div>\n<p>Image #3<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<ul>\n<li>All the tables in your database will appear. If not, click <strong>Structure<\/strong>.<\/li>\n<li>Look for <strong>wp_users<\/strong>.<\/li>\n<li>Click on the icon for <strong>browse<\/strong>.<\/li>\n<li>Locate your Username under user_login<\/li>\n<li>Click <strong>edit<\/strong><\/li>\n<\/ul>\n<\/div>\n<div>\n<div>\n<div>\n<div><a title=\"Image #4\" href=\"http:\/\/codex.wordpress.org\/File:changepw6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/images\/thumb\/8\/80\/changepw6.jpg\/180px-changepw6.jpg\" alt=\"\" width=\"180\" height=\"60\" border=\"0\" \/><\/a><\/p>\n<div>\n<div><a title=\"Enlarge\" href=\"http:\/\/codex.wordpress.org\/File:changepw6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/skins\/common\/images\/magnify-clip.png\" alt=\"\" width=\"15\" height=\"11\" \/><\/a><\/div>\n<p>Image #4<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<ul>\n<li>Your user_id will be shown, click on Edit<\/li>\n<li>Next to the user_pass is a long list of numbers and letters.<\/li>\n<li>Select and delete these and type in your new password.<\/li>\n<li>Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.<\/li>\n<li>In this example, the new password will be &#8216;rabbitseatcarrots&#8217;<\/li>\n<li>Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.<\/li>\n<\/ul>\n<\/div>\n<div>\n<div>\n<div>\n<div><a title=\"Image #5\" href=\"http:\/\/codex.wordpress.org\/File:changepw7.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/images\/thumb\/6\/63\/changepw7.jpg\/180px-changepw7.jpg\" alt=\"\" width=\"180\" height=\"33\" border=\"0\" \/><\/a><\/p>\n<div>\n<div><a title=\"Enlarge\" href=\"http:\/\/codex.wordpress.org\/File:changepw7.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/codex.wordpress.org\/skins\/common\/images\/magnify-clip.png\" alt=\"\" width=\"15\" height=\"11\" \/><\/a><\/div>\n<p>Image #5<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<ul>\n<li>Check that your password is actually correct, and that MD5 is in the box.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li>Click the &#8216;Go&#8217; button to the bottom right.<\/li>\n<li>Test the new password on the login screen. If it doesn&#8217;t work, check that you&#8217;ve followed these instructions exactly.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div>\u00a0<\/div>\n<p><a id=\"Other_Tutorials_using_phpMyAdmin\" name=\"Other_Tutorials_using_phpMyAdmin\"><\/a><\/p>\n<h3>Other Tutorials using phpMyAdmin<\/h3>\n<ul>\n<li><a title=\"http:\/\/www.tamba2.org.uk\/wordpress\/phpmyadmin\/\" href=\"http:\/\/www.tamba2.org.uk\/wordpress\/phpmyadmin\/\">phpMyAdmin at tamba2<\/a><\/li>\n<li><a title=\"http:\/\/www.devlounge.net\/articles\/reset-a-wordpress-password-from-phpmyadmin\" href=\"http:\/\/www.devlounge.net\/articles\/reset-a-wordpress-password-from-phpmyadmin\">Reset a WordPress password from phpMyAdmin<\/a><\/li>\n<\/ul>\n<p><a id=\"Through_FTP\" name=\"Through_FTP\"><\/a><\/p>\n<h2>Through FTP<\/h2>\n<p>There is also an easy way to reset your password via FTP, if you&#8217;re using the admin user.<\/p>\n<p>1. Login to your site via FTP and download your active theme&#8217;s functions.php file.<\/p>\n<p>2. Edit the file and add this code to it, right at the beginning, after the first &lt;?php:<\/p>\n<pre>wp_set_password('password',1);<\/pre>\n<p>Put in your own new password for the main admin user. The &#8220;1&#8221; is the user ID number in the wp_users table.<\/p>\n<p>3. Upload the modified file back to your site.<\/p>\n<p>4. After you then are able to login, make sure to go back and remove that code. It will reset your password on every page load until you do.<\/p>\n<p><a id=\"Using_the_Emergency_Password_Reset_Script\" name=\"Using_the_Emergency_Password_Reset_Script\"><\/a><\/p>\n<h2>Using the Emergency Password Reset Script<\/h2>\n<p>If the other solutions listed above won&#8217;t work, then try the Emergency Password Reset Script. It is not a Plugin. It is a PHP script.<\/p>\n<dl>\n<dt>Warnings\u00a0<\/dt>\n<dd><\/dd>\n<\/dl>\n<ol>\n<li>Requires you know the administrator username.<\/li>\n<li>It updates the administrator password and sends an email to the administrator&#8217;s email address.<\/li>\n<li>If you don&#8217;t receive the email, the password is still changed.<\/li>\n<li>You do not need to be logged in to use it. If you could login, you wouldn&#8217;t need the script.<\/li>\n<li>Place this in the root of your WordPress installation. Do not upload this to your WordPress Plugins directory.<\/li>\n<li>Delete the script when you are done for security reasons.<\/li>\n<\/ol>\n<dl>\n<dt>Directions for use\u00a0<\/dt>\n<dd><\/dd>\n<\/dl>\n<ol>\n<li>Copy the emergency script from <a title=\"http:\/\/codex.wordpress.org\/User:MichaelH\/Orphaned_Plugins_needing_Adoption\/Emergency\" href=\"http:\/\/codex.wordpress.org\/User:MichaelH\/Orphaned_Plugins_needing_Adoption\/Emergency\">Emergency Password Script<\/a> and put into a file called emergency.php in the root of your WordPress installation (the same directory that contains wp-config.php).<\/li>\n<li>In your browser, open http:\/\/example.com\/emergency.php.<\/li>\n<li>As instructed, enter the administrator username (usually admin) and the new password, then click <strong>Update Options<\/strong>. A message is displayed noting the changed password. An email is sent to the blog administrator with the changed password information.<\/li>\n<li><strong>Delete emergency.php from your server when you are done.<\/strong> Do not leave it on your server as someone else could use it to change your password.<\/li>\n<\/ol>\n<p><a id=\"Changing_your_password_in_older_versions\" name=\"Changing_your_password_in_older_versions\"><\/a><\/p>\n<h2>Changing your password in older versions<\/h2>\n<p>To change your password in <strong>WordPress v1.2<\/strong>:<\/p>\n<ol>\n<li>In the Admin Panel, go to PROFILE<\/li>\n<li>Scroll down to the bottom and type in the new password in the two boxes provided<\/li>\n<li>Click the UPDATE PROFILE button<\/li>\n<\/ol>\n<dl>\n<dd>Your new password takes effect immediately.<\/dd>\n<\/dl>\n<p>To change your password in <strong>WordPress v1.5<\/strong>:<\/p>\n<ol>\n<li>In the Admin Panel, go to USERS<\/li>\n<li>From the &#8220;Your Profile&#8221; tab, scroll to the bottom and type in the new password in the two boxes provided.<\/li>\n<li>Click the UPDATE PROFILE button<\/li>\n<\/ol>\n<dl>\n<dd>Your new password takes effect immediately.<\/dd>\n<\/dl>\n<p>To change your password in <strong>WordPress v2.0<\/strong>:<\/p>\n<ol>\n<li>In the Admin Panel, go to USERS (or Profile)<\/li>\n<li>From the &#8220;Your Profile&#8221; tab, scroll down to the Update Your Password section and type in a new password in the two boxes provided.<\/li>\n<li>Click the UPDATE PROFILE button<\/li>\n<\/ol>\n<dl>\n<dd>Your new password takes effect immediately.<\/dd>\n<\/dl>\n<p>&nbsp;<\/p>\n<p><a id=\"Additional_Reference\" name=\"Additional_Reference\"><\/a><\/p>\n<h2>Additional Reference<\/h2>\n<ul>\n<li><a title=\"http:\/\/www.jojojoson.com\/forgot-wordpress-administrator-e-mail-and-username.html\/\" href=\"http:\/\/www.jojojoson.com\/forgot-wordpress-administrator-e-mail-and-username.html\/\">How to Recover WordPress Administrator E-mail<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0In WordPress, there is more than one way to set your password. In normal circumstances, you can do it through the WordPress interface. If you forget your password, WordPress has a built in recovery mechanism that uses email. But on some hosts, especially when email isn&#8217;t working right, sometimes you have to take different steps [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3630,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"h5ap_radio_sources":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1473","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/posts\/1473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1473"}],"version-history":[{"count":0,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/posts\/1473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=\/wp\/v2\/media\/3630"}],"wp:attachment":[{"href":"http:\/\/www.webputzer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1473"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.webputzer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}