{"id":156,"date":"2025-02-17T22:43:45","date_gmt":"2025-02-17T16:43:45","guid":{"rendered":"https:\/\/jettcode.com\/blog\/?p=156"},"modified":"2025-02-12T22:44:31","modified_gmt":"2025-02-12T16:44:31","slug":"how-to-change-a-wordpress-password-using-the-database","status":"publish","type":"post","link":"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/","title":{"rendered":"How to Change a WordPress Password Using the Database"},"content":{"rendered":"<p>Hey there! Forgot your WordPress password and can\u2019t log in? No worries\u2014you can reset it directly from your database! In this article, we\u2019ll walk you through the steps to change your WordPress password using phpMyAdmin or a similar database tool. Don\u2019t worry if you\u2019re not a tech expert\u2014we\u2019ll keep it simple and easy to follow. Let\u2019s get started!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Why_Change_Your_Password_via_the_Database\" title=\"Why Change Your Password via the Database?\">Why Change Your Password via the Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Step_1_Access_Your_Database\" title=\"Step 1: Access Your Database\">Step 1: Access Your Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Step_2_Find_the_Users_Table\" title=\"Step 2: Find the Users Table\">Step 2: Find the Users Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Step_3_Locate_Your_User_Account\" title=\"Step 3: Locate Your User Account\">Step 3: Locate Your User Account<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Step_4_Change_Your_Password\" title=\"Step 4: Change Your Password\">Step 4: Change Your Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Step_5_Log_In_to_WordPress\" title=\"Step 5: Log In to WordPress\">Step 5: Log In to WordPress<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#Pro_Tip_Use_a_Strong_Password\" title=\"Pro Tip: Use a Strong Password\">Pro Tip: Use a Strong Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#What_If_You_Dont_Have_phpMyAdmin\" title=\"What If You Don\u2019t Have phpMyAdmin?\">What If You Don\u2019t Have phpMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/jettcode.com\/blog\/how-to-change-a-wordpress-password-using-the-database\/#The_Bottom_Line\" title=\"The Bottom Line\">The Bottom Line<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_Change_Your_Password_via_the_Database\"><\/span>Why Change Your Password via the Database?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sometimes, you might lose access to your WordPress admin dashboard or the email linked to your account. When that happens, changing your password directly in the database is a lifesaver. It\u2019s a bit technical, but with this guide, you\u2019ll have it done in no time!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_1_Access_Your_Database\"><\/span>Step 1: Access Your Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First, you\u2019ll need to access your WordPress database. Most hosting providers offer a tool called <strong>phpMyAdmin<\/strong> to manage databases. Here\u2019s how to find it:<\/p>\n<ol>\n<li>Log in to your hosting control panel (like cPanel).<\/li>\n<li>Look for the <strong>Databases<\/strong> section and click on <strong>phpMyAdmin<\/strong>.<\/li>\n<li>Select your WordPress database from the list on the left.<\/li>\n<\/ol>\n<p>If you\u2019re not sure which database your WordPress site uses, check the <code>wp-config.php<\/code> file in your WordPress installation. Look for the line that says <code>DB_NAME<\/code>\u2014that\u2019s your database name.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_2_Find_the_Users_Table\"><\/span>Step 2: Find the Users Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you\u2019re in the database, look for the table named <code>wp_users<\/code>. (The prefix <code>wp_<\/code> might be different if you changed it during installation.)<\/p>\n<p>This table stores all the user information, including usernames and passwords.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-1-1024x461.png\" alt=\"Image of How to Change a WordPress Password Using the Database on JettCode\" width=\"1024\" height=\"461\" class=\"aligncenter size-large wp-image-160\" srcset=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-1-1024x461.png 1024w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-1-300x135.png 300w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-1-768x346.png 768w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-1.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_3_Locate_Your_User_Account\"><\/span>Step 3: Locate Your User Account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click on the <code>wp_users<\/code> table to open it. You\u2019ll see a list of all the users registered on your WordPress site. Find your username in the <code>user_login<\/code> column.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-2-1024x461.png\" alt=\"Image of How to Change a WordPress Password Using the Database on JettCode\" width=\"1024\" height=\"461\" class=\"aligncenter size-large wp-image-161\" srcset=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-2-1024x461.png 1024w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-2-300x135.png 300w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-2-768x346.png 768w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-2.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_4_Change_Your_Password\"><\/span>Step 4: Change Your Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now, it\u2019s time to reset your password. Here\u2019s how:<\/p>\n<ol>\n<li>Click the <strong>Edit<\/strong> button next to your username.<\/li>\n<li>In the <code>user_pass<\/code> field, you\u2019ll see a hashed password (a long string of random characters). Delete it.<\/li>\n<li>Enter your new password in the same field.<\/li>\n<li>In the <strong>Function<\/strong> dropdown next to the <code>user_pass<\/code> field, select <strong>MD5<\/strong>. (WordPress uses MD5 hashing to encrypt passwords.)<\/li>\n<li>Click <strong>Go<\/strong> to save your changes.<\/li>\n<\/ol>\n<p>That\u2019s it! Your password has been updated.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-3-1024x461.png\" alt=\"Image of How to Change a WordPress Password Using the Database on JettCode\" width=\"1024\" height=\"461\" class=\"aligncenter size-large wp-image-162\" srcset=\"https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-3-1024x461.png 1024w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-3-300x135.png 300w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-3-768x346.png 768w, https:\/\/jettcode.com\/blog\/wp-content\/uploads\/2025\/02\/how-to-change-a-wordpress-password-using-the-database-jettcode-3.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step_5_Log_In_to_WordPress\"><\/span>Step 5: Log In to WordPress<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Head back to your WordPress login page and enter your username and new password. You should now be able to access your dashboard!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Pro_Tip_Use_a_Strong_Password\"><\/span>Pro Tip: Use a Strong Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>While you\u2019re at it, make sure your new password is strong and secure. Use a mix of uppercase and lowercase letters, numbers, and special characters. You can also use a password manager to generate and store strong passwords.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_If_You_Dont_Have_phpMyAdmin\"><\/span>What If You Don\u2019t Have phpMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If your hosting provider doesn\u2019t offer phpMyAdmin, don\u2019t worry! You can use other tools like <strong>Adminer<\/strong> or even run SQL queries directly. The process is similar\u2014just locate the <code>wp_users<\/code> table and update the <code>user_pass<\/code> field.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_Bottom_Line\"><\/span>The Bottom Line<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Changing your WordPress password via the database might sound intimidating, but it\u2019s actually pretty straightforward once you know the steps. Whether you\u2019re locked out of your account or just want to update your password, this method is a reliable way to regain access.<\/p>\n<p>Got questions or need help? Drop a comment below\u2014I\u2019d love to hear from you!<\/p>\n<p>Happy WordPress-ing, and may your passwords always be secure! \ud83d\ude80<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hey there! Forgot your WordPress password and can\u2019t log in? No worries\u2014you can reset it&hellip;<\/p>\n","protected":false},"author":1,"featured_media":165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress"],"_links":{"self":[{"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/posts\/156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":5,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/posts\/156\/revisions"}],"predecessor-version":[{"id":164,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/posts\/156\/revisions\/164"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/media\/165"}],"wp:attachment":[{"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/media?parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/categories?post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jettcode.com\/blog\/wp-json\/wp\/v2\/tags?post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}