{"id":305,"date":"2025-12-28T20:24:20","date_gmt":"2025-12-28T19:24:20","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=305"},"modified":"2026-06-02T05:33:35","modified_gmt":"2026-06-02T03:33:35","slug":"how-do-i-change-my-wordpress-password-through-the-database","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-do-i-change-my-wordpress-password-through-the-database\/","title":{"rendered":"How do I change my WordPress password through the database?"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">By default, WordPress allows password reset through the login page using the \u201cForgot password\u201d option. A reset link is sent to the email address associated with the user account.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you do not have access to the mailbox, you can reset the password directly in the database using phpMyAdmin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom 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\"><\/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:\/\/mybox.com\/help\/en\/knowledgebase\/how-do-i-change-my-wordpress-password-through-the-database\/#Steps_to_change_the_password_via_database\" >Steps to change the password via 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:\/\/mybox.com\/help\/en\/knowledgebase\/how-do-i-change-my-wordpress-password-through-the-database\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Steps_to_change_the_password_via_database\"><\/span>Steps to change the password via database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<\/div>\n\n<div id=\"mybox-2725428594\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Early access<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Still need help?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contact our customer service team.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Message us<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\"><strong>1.<\/strong> Log in to the myBox panel, select the <em><strong>&#8220;Databases&#8221;<\/strong><\/em> section from the menu on the left, and click the <a href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/access-to-the-database-via-phpmyadmin\/\"><em><strong>&#8220;phpMyAdmin&#8221;<\/strong><\/em><\/a> button on the page that appears.<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"275\" height=\"249\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-177.png\" alt=\"\" class=\"wp-image-4210\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-177.png 275w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-177-13x12.png 13w\" sizes=\"auto, (max-width: 275px) 100vw, 275px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\"><strong>2.<\/strong> After logging in to the database, select the <strong>wp_users<\/strong> table in the column on the left.<br>Keep in mind that sometimes the so-called prefix can be different, so look for a table called <strong>string-character_users<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>If you do not know the login and password to the database related to the <strong>&#8220;WordPress&#8221;<\/strong> script, read the guide located &#8211; <a href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/obtaining-the-login-and-password-to-the-database-from-the-wp-config-php-file\/\">HERE<\/a><\/em><\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"399\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-178.png\" alt=\"\" class=\"wp-image-4212\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-178.png 222w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-178-167x300.png 167w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-178-7x12.png 7w\" sizes=\"auto, (max-width: 222px) 100vw, 222px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\"><strong>3.<\/strong> After loading the table contents, you will receive a list of users who have created accounts within your website. Find the user you want to change the password for and click on the <em><strong>&#8220;edit&#8221; <\/strong><\/em>or <em><strong>&#8220;edit&#8221;<\/strong><\/em> button (in English)<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"116\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-179.png\" alt=\"\" class=\"wp-image-4213\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-179.png 670w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-179-300x52.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-179-18x3.png 18w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\"><strong>4.<\/strong> Then search for the field named <em><strong>&#8220;user_pass&#8221;<\/strong><\/em>, select the <em><strong>&#8220;MD5&#8221;<\/strong><\/em> method from the drop-down list and enter the password you want to set for the edited user in the value field where the string is located, e.g. <strong>my-new-password-123<\/strong>. Once you have performed the action, your new password will be encrypted and will be presented as a barely legible string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Remember or save in a safe place the new password you set in this step.<\/p>\n\n\n\n<\/div>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"435\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-180.png\" alt=\"\" class=\"wp-image-4214\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-180.png 840w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-180-300x155.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-180-768x398.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-180-18x9.png 18w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.<\/strong> The last step is to confirm the change with the <em><strong>&#8220;execute&#8221; <\/strong><\/em>or <em><strong>&#8220;go&#8221;<\/strong><\/em> button (in English)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can log in to your WordPress dashboard using your new password.<\/p>\n\n\n\n<div class=\"wp-block-onethird-callout-box onethird-callout-wrap\"><div class=\"onethird-callout onethird-callout--warn\" style=\"--ot-bg:#FFEAE9;--ot-border:#F8D0D0;--ot-text:#6F7C88;--ot-title:#384048;--ot-body:#6F7C88;--ot-icon:#384048;border-radius:6px;padding:16px\"><div class=\"onethird-callout__head\"><span class=\"onethird-callout__icon\"><svg viewBox=\"0 0 24 24\" width=\"18\" height=\"18\" aria-hidden=\"true\" focusable=\"false\"><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 3 2.5 20.5h19L12 3z\"><\/path><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 9v5\"><\/path><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 17h.01\"><\/path><\/svg><\/span><div class=\"onethird-callout__title\">Note!<\/div><\/div><div class=\"onethird-callout__body\">Make sure to store the new password securely, as it will not be shown again in plain text after saving.<\/div><\/div><div class=\"onethird-callout__separator\" style=\"height:18px\" aria-hidden=\"true\"><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If email-based password recovery is not available, you can reset a WordPress password directly in the database via phpMyAdmin by editing the <code>user_pass<\/code> field in the <code>wp_users<\/code> table and saving a new MD5-hashed value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25,58],"manual_kb_tag":[962,3660,3661,3662,3663,3664,3665,3666,3667,3668,3669,3670,3671,3672],"class_list":["post-305","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manualknowledgebasecat-web-applications-cms","manual_kb_tag-hosting-control-panel","manual_kb_tag-wordpress-password-reset","manual_kb_tag-change-wordpress-password","manual_kb_tag-reset-password-via-database","manual_kb_tag-change-password-in-database","manual_kb_tag-phpmyadmin-password-reset","manual_kb_tag-wordpress-users-table","manual_kb_tag-user-password-field","manual_kb_tag-reset-without-email","manual_kb_tag-database-password-update","manual_kb_tag-mysql-password-reset","manual_kb_tag-reset-wordpress-password","manual_kb_tag-md-password-hashing","manual_kb_tag-wordpress-login-recovery"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":3,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/305\/revisions"}],"predecessor-version":[{"id":4215,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/305\/revisions\/4215"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=305"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=305"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}