{"id":361,"date":"2016-01-02T17:41:54","date_gmt":"2016-01-02T09:41:54","guid":{"rendered":"http:\/\/www.sysadmindayph.com\/blog\/?p=361"},"modified":"2019-10-16T14:40:37","modified_gmt":"2019-10-16T06:40:37","slug":"how-to-reset-a-wordpress-password","status":"publish","type":"post","link":"https:\/\/www.sysadmindayph.com\/blog\/how-to-reset-a-wordpress-password\/","title":{"rendered":"How to Reset a WordPress Password"},"content":{"rendered":"\n<p>There are a number of ways to reset a WordPress admin password if you happen to forget it.<\/p>\n\n\n\n<p>For this post, let me share you a way to reset it using the CPANEL and updating the record in the wp_users table in your wordpress database.<\/p>\n\n\n\n<p>You will be using myPHpadmin of course.<\/p>\n\n\n\n<figure><iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/MqPKyyQ6RbA\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe><\/figure>\n\n\n\n<!--more-->\n\n\n\n<p>Basically, below is the steps done that is also explained in the video:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 \u2013 Identify the Name of your Database<\/h3>\n\n\n\n<p>It is always good to know the name of your WordPress Database. <\/p>\n\n\n\n<p>Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password. <\/p>\n\n\n\n<p>The best place to look is your <strong>wp-config.php<\/strong> file which is located in your root WordPress Directory. In there you will find the name of your database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 \u2013 Locating Database and Editing the Fields<\/h3>\n\n\n\n<p>In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.<\/p>\n\n\n\n<p>Once you are in phpMyAdmin, you will need to select the correct database on the left hand side. <\/p>\n\n\n\n<p>Look for the name that you found in your wp-config.php and click on that. You will see a list of tables with a prefix wp_ for the most part.<\/p>\n\n\n\n<p>If you changed your prefix during installation, then you would be looking for that specific prefix \u201cfor ex: wp673_\u201d.<\/p>\n\n\n\n<p>You will look for the table <strong>wp_users<\/strong>, click on it and then click on the Browse Tab.<\/p>\n\n\n\n<p>Click on the Pencil (Edit) Icon to reset your Password.<\/p>\n\n\n\n<p>Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. <\/p>\n\n\n\n<p>Due to security reasons, WordPress stores the passwords as <a href=\"http:\/\/en.wikipedia.org\/wiki\/MD5\" target=\"_blank\" rel=\"noopener noreferrer\">MD5 Hash<\/a> rather than Plain text.<\/p>\n\n\n\n<p>This means that you will not be able to enter plain text as the password. You would need to use one of the MD5 generators online to generate your password.<\/p>\n\n\n\n<p>Recommended Tool: <a href=\"http:\/\/pajhome.org.uk\/crypt\/md5\/\" target=\"_blank\" rel=\"noopener noreferrer\">JavaScript MD5<\/a><\/p>\n\n\n\n<p>Simply type your password in that tool and generate MD5 results. <\/p>\n\n\n\n<p>Copy and paste the code you get from the converter into your phpMyAdmin field and click Go to save changes.<\/p>\n\n\n\n<p>You have now successfully changed your WordPress Password from phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a number of ways to reset a WordPress admin password if you happen to forget it. For this post, let me share you a way to reset it using the CPANEL and updating &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[317],"tags":[393,394,392],"class_list":["post-361","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-myphpadmin","tag-password-reset","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/posts\/361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/comments?post=361"}],"version-history":[{"count":3,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/posts\/361\/revisions"}],"predecessor-version":[{"id":545,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/posts\/361\/revisions\/545"}],"wp:attachment":[{"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/media?parent=361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/categories?post=361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sysadmindayph.com\/blog\/wp-json\/wp\/v2\/tags?post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}