{"id":4771,"date":"2021-10-10T22:13:04","date_gmt":"2021-10-10T22:13:04","guid":{"rendered":"https:\/\/www.cldy.com\/support\/?post_type=docs&#038;p=4771"},"modified":"2022-12-18T00:15:50","modified_gmt":"2022-12-17T16:15:50","password":"","slug":"how-to-reset-wordpress-password-via-phpmyadmin","status":"publish","type":"docs","link":"https:\/\/www.cldy.com\/support\/help\/how-to-reset-wordpress-password-via-phpmyadmin\/","title":{"rendered":"How to Reset WordPress Password via phpMyAdmin?"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">You can easily change your WordPress password using phpMyAdmin, by following these steps:<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Log in to your cPanel.<br \/><br \/><\/li>\r\n<li>Under <em>Databases<\/em>, click on <strong>phpMyAdmin<\/strong>.<br \/><br \/><img decoding=\"async\" width=\"540\" height=\"320\" class=\"wp-image-4772\" style=\"width: 540px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_cpanel-databases-phpmyadmin.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_cpanel-databases-phpmyadmin.png 1064w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_cpanel-databases-phpmyadmin-300x178.png 300w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_cpanel-databases-phpmyadmin-1024x606.png 1024w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_cpanel-databases-phpmyadmin-768x455.png 768w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><br \/><br \/><\/li>\r\n<li>Click on <strong>+ <\/strong>to expand the selections under your WordPress database. Then click on the item with <strong>_users<\/strong>.<br \/><br \/><img decoding=\"async\" width=\"240\" height=\"422\" class=\"wp-image-4773\" style=\"width: 240px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-list-expand.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-list-expand.png 390w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-list-expand-171x300.png 171w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/> <img decoding=\"async\" width=\"240\" height=\"421\" class=\"wp-image-4774\" style=\"width: 240px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-expanded-list-select-users.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-expanded-list-select-users.png 392w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-expanded-list-select-users-171x300.png 171w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/><br \/><br \/><\/li>\r\n<li>Your screen will now look like this:<br \/><br \/><img decoding=\"async\" width=\"720\" height=\"343\" class=\"wp-image-4775\" style=\"width: 720px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-users-edit.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-users-edit.png 1436w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-users-edit-300x143.png 300w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-users-edit-1024x488.png 1024w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_database-users-edit-768x366.png 768w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><br \/><br \/>Find the username you need to change the password for, and click on the <strong>Edit<\/strong> button along its row.<br \/><br \/><\/li>\r\n<li>Find the <em>user_pass<\/em> row, and fill in your preferred password on the text box.<br \/><br \/><img decoding=\"async\" width=\"720\" height=\"319\" class=\"wp-image-4776\" style=\"width: 720px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-md5.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-md5.png 1436w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-md5-300x133.png 300w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-md5-1024x454.png 1024w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-md5-768x340.png 768w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><br \/><br \/>Make sure to also select <strong>MD5 <\/strong>from the dropdown beside the password field.<br \/><br \/>We recommend that you set a strong password that is not easily remembered, therefore much more secure and protected. Make sure your password contains:<br \/>&#8211; At least 1 numeric character<br \/>&#8211; At least 1 lower case and upper case character<br \/>&#8211; At least 1 symbol (!(@$=&#8230;)<br \/>&#8211; Have a total of 12 to 16 characters<br \/><br \/><em>* Stray from passwords that can be linked to your personal information such as your name, your birthday, your home address, etc.<\/em><br \/><br \/>We also encourage you to utilize a password manager to keep your passwords updated and stored safely.<br \/><br \/>Confirm the password you have set, and click on<strong> Go.<\/strong><br \/><br \/><img decoding=\"async\" width=\"720\" height=\"320\" class=\"wp-image-4777\" style=\"width: 720px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-go.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-go.png 1435w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-go-300x133.png 300w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-go-1024x455.png 1024w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-go-768x341.png 768w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><br \/><br \/><\/li>\r\n<li>You will be back to the <strong>_users<\/strong> page, and this prompt will show up at the top of the window:<br \/><br \/><img decoding=\"async\" width=\"720\" height=\"264\" class=\"wp-image-4778\" style=\"width: 720px;\" src=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-successful.png\" alt=\"\" srcset=\"https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-successful.png 1436w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-successful-300x110.png 300w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-successful-1024x375.png 1024w, https:\/\/www.cldy.com\/support\/wp-content\/uploads\/sites\/12\/2021\/10\/phpmyadmin_reset-wordpress-password_edit-user-password-successful-768x281.png 768w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><br \/><br \/>To confirm the password change, go to your WordPress account and log in using your new credentials.<\/li>\r\n<\/ol>\r\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; You can easily change your WordPress password using phpMyAdmin, by following these steps: &nbsp; Log in to your cPanel. Under Databases, click on phpMyAdmin. Click on + to expand the selections under your WordPress database. Then click on the item with _users. Your screen will now look like this: Find the username you need [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[47],"doc_tag":[],"class_list":["post-4771","docs","type-docs","status-publish","hentry","doc_category-cpanel"],"year_month":"2026-06","word_count":228,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"syd123","author_nicename":"syd123","author_url":"https:\/\/www.cldy.com\/support\/author\/syd123\/"},"doc_category_info":[{"term_name":"cPanel","term_url":"https:\/\/www.cldy.com\/support\/help-category\/cpanel\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/docs\/4771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/comments?post=4771"}],"version-history":[{"count":2,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/docs\/4771\/revisions"}],"predecessor-version":[{"id":7406,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/docs\/4771\/revisions\/7406"}],"wp:attachment":[{"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/media?parent=4771"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/doc_category?post=4771"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.cldy.com\/support\/wp-json\/wp\/v2\/doc_tag?post=4771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}