{"id":25903,"date":"2020-12-21T02:52:30","date_gmt":"2020-12-20T18:52:30","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&#038;p=25903"},"modified":"2022-09-08T21:25:16","modified_gmt":"2022-09-08T13:25:16","slug":"how-to-reset-a-wordpress-password-with-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/how-to-reset-a-wordpress-password-with-phpmyadmin","title":{"rendered":"HOW TO: Reset a WordPress Password with phpMyadmin"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"25903\" class=\"elementor elementor-25903\" data-elementor-post-type=\"kb\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-436b477 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"436b477\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-53cbb7b\" data-id=\"53cbb7b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a41626 elementor-widget elementor-widget-heading\" data-id=\"0a41626\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">HOW TO: Reset a WordPress Password with phpMyadmin\n<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45a6b9a elementor-widget elementor-widget-text-editor\" data-id=\"45a6b9a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To reset a WordPress Password with phpMyadmin, you would need to take a few steps. In other words, you need to access PHPMyAdmin and then enter a new password.<\/p><p>In this article, we will show you how to perform these simple actions in detail.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-830c693 elementor-widget elementor-widget-heading\" data-id=\"830c693\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">i) Access phpMyAdmin<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e999f2e elementor-widget elementor-widget-text-editor\" data-id=\"e999f2e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>These steps explain how to access phpMyAdmin.<\/p><ol><li>From your account\u00a0<strong>cpanel<\/strong>, go to the\u00a0<strong>databases group of icons<\/strong>, and click on\u00a0<strong>phpMyAdmin<\/strong><\/li><li>When prompted\u00a0<strong>login with your cpanel username and password<\/strong>.<\/li><li>From the list of databases,\u00a0<strong>select the database for your WordPress site.<\/strong><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-604ce32 elementor-widget elementor-widget-heading\" data-id=\"604ce32\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">ii) Enter a New Password<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ffb701 elementor-widget elementor-widget-text-editor\" data-id=\"7ffb701\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>These steps explain how to change the password in the database.<\/p><ol><li>In the table list,\u00a0<strong>click on the users table<\/strong><br \/><strong>Note:<\/strong> In our example, the table prefix is \u201cwp_\u201d the prefix varies from site to site so don\u2019t worry if yours is different.<\/li><li><strong>Click edit<\/strong>\u00a0next to the user you want to set the password for.<\/li><li><strong>Enter the new password<\/strong>\u00a0into the password box<\/li><li>In the function box next to the password\u00a0<strong>choose MD5<\/strong><\/li><li>Click Go<\/li><\/ol><p>Congratulations! You have successfully changed your WordPress password using phpMyAdmin. So, you can now login to WordPress with your new password.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-578bf8b elementor-widget elementor-widget-heading\" data-id=\"578bf8b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Why You Should Reset a WordPress Password<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-91c1c05 elementor-widget elementor-widget-text-editor\" data-id=\"91c1c05\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>There are several reasons why you would need to reset a WordPress password. If your website ever gets hacked, or for some reason, you cannot log in back to your website, the only way back in is to reset the WordPress password.<\/p><p>There are several methods you can use to reset a WordPress password for a specific account. You can\u00a0reset a WordPress password using FTP, or as explained in this article, you can reset the WordPress password using the phpMyAdmin web interface. Follow the three easy steps in this WordPress admin tip\u00a0to reset a WordPress password within a minute and gain back access to your WordPress blog or website.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3783f13 elementor-widget elementor-widget-heading\" data-id=\"3783f13\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-medium\">Extra information<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72d61f8 elementor-widget elementor-widget-text-editor\" data-id=\"72d61f8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Your password is encrypted using the MD5 hash and stored in the database. However, some of you may be wondering the reason to select the MD5 hash to encrypt the password.<\/p><p>In the older version, WordPress used the MD5 hash to encrypt passwords. Since WordPress 2.5, it started using stronger encryption technologies. However, WordPress still recognizes MD5 to provide backward compatibility.<\/p><p>As soon as you log in using a password string stored as an MD5 hash, WordPress recognizes it and changes it using the newer encryption algorithms.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>HOW TO: Reset a WordPress Password with phpMyadmin To reset a WordPress Password with phpMyadmin, you would need to take a few steps. In other words, you need to access PHPMyAdmin and then enter a new password. In this article, we will show you how to perform these simple actions in detail. i) Access phpMyAdmin [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[43],"kbtag":[106],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/25903"}],"collection":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/comments?post=25903"}],"version-history":[{"count":2,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/25903\/revisions"}],"predecessor-version":[{"id":32032,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/25903\/revisions\/32032"}],"wp:attachment":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/media?parent=25903"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=25903"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtag?post=25903"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=25903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}