{"id":1389,"date":"2022-02-24T12:38:35","date_gmt":"2022-02-24T07:08:35","guid":{"rendered":"https:\/\/hostkicker.com\/blog\/?p=1389"},"modified":"2022-05-17T11:38:33","modified_gmt":"2022-05-17T06:08:33","slug":"how-to-reset-a-wordpress-password-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","title":{"rendered":"How to Reset a WordPress Password from phpMyAdmin"},"content":{"rendered":"

Would you like to reset the WordPress password using phpMyAdmin?<\/span><\/p>\n

If you cannot recover your lost WordPress password, you can reset it directly in your WordPress database using phpMyAdmin.<\/span><\/p>\n

Here, we will share how to easily reset a WordPress password from phpMyAdmin.<\/span><\/p>\n

Why Reset WordPress Password from phpMyAdmin?<\/span><\/h4>\n

WordPress allows you to recover a<\/span>\u00a0lost password<\/a> easily<\/span><\/strong>.<\/span><\/strong>\u00a0You can visit your WordPress login screen and click on the ‘Lost your password?’ link provided there.<\/span><\/p>\n

Click the link to reach the password reset page.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

When you place your username or email address, WordPress sends a password reset link to the linked email address.<\/span><\/p>\n

If you want to recover a lost password step by step, you can see our tutorial on<\/span>\u00a0recovering a lost password in WordPress.<\/span><\/strong><\/a><\/p>\n

But, if you can’t access that email address or your site fails to send an email, then you can’t reset your password.<\/span><\/p>\n

In that case, you have to reset your password directly from phpMyAdmin.<\/span><\/p>\n

Method to Reset WordPress Password From PhpMyAdmin<\/span><\/h4>\n

To set your WordPress password from phpMyAdmin, log in to the cPanel dashboard of your WordPress hosting account. Then, visit the Databases section, look for the phpMyAdmin icon, and click on it.<\/span><\/p>\n

\"\"<\/p>\n

After clicking the phpMyAdmin icon, it will launch the phpMyAdmin app, where you have to select your WordPress database.<\/span><\/p>\n

\"\"<\/p>\n

You will notice a list of tables in your WordPress database. You have to search for the wp_users<\/em> table in that list and click the Browse link beside it.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

Note:<\/span><\/strong>\u00a0Your WordPress database table names may differ from those in our image.<\/span><\/p>\n

Now, You will notice the rows in your WordPress users table. Click on the edit tab next to the username whose password you want to change.<\/span><\/p>\n

\"\"<\/p>\n

After that, PhpMyAdmin will display a form with all the user details fields.<\/span><\/p>\n

You will have to delete the value in the user_pass field and enter your new password. In the function column, select MD5 from the drop-down menu and then click the Go tab at the bottom of the form.<\/span><\/p>\n

\"\"<\/p>\n

Now, it will encrypt Your password using the MD5 hash, and then it will store it in the database.<\/span><\/p>\n

Now, You have changed your WordPress password using phpMyAdmin successfully.<\/span><\/p>\n

We hope this tutorial helped you learn how to reset a WordPress password from phpMyAdmin.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Would you like to reset the WordPress password using phpMyAdmin? If you cannot recover your lost WordPress password, you can reset it directly in your WordPress database using phpMyAdmin. Here, we will share how to easily reset a WordPress password from phpMyAdmin. Why Reset WordPress Password from phpMyAdmin? WordPress allows you to recover a\u00a0lost password […]<\/p>\n","protected":false},"author":4,"featured_media":1493,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1389","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wp-tutorials"],"yoast_head":"\nHow to Reset a WordPress Password from phpMyAdmin - Hostkicker<\/title>\n<meta name=\"description\" content=\"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Reset a WordPress Password from phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostkicker\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-24T07:08:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-17T06:08:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png\" \/>\n\t<meta property=\"og:image:width\" content=\"693\" \/>\n\t<meta property=\"og:image:height\" content=\"511\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Olivia Smith\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/\"},\"author\":{\"name\":\"Olivia Smith\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#\\\/schema\\\/person\\\/f06306b595baa96c90a0491b941d7660\"},\"headline\":\"How to Reset a WordPress Password from phpMyAdmin\",\"datePublished\":\"2022-02-24T07:08:35+00:00\",\"dateModified\":\"2022-05-17T06:08:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/\"},\"wordCount\":392,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/MicrosoftTeams-image-46.png\",\"articleSection\":[\"Wp tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/\",\"name\":\"How to Reset a WordPress Password from phpMyAdmin - Hostkicker\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/MicrosoftTeams-image-46.png\",\"datePublished\":\"2022-02-24T07:08:35+00:00\",\"dateModified\":\"2022-05-17T06:08:33+00:00\",\"description\":\"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/MicrosoftTeams-image-46.png\",\"contentUrl\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/MicrosoftTeams-image-46.png\",\"width\":693,\"height\":511,\"caption\":\"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/how-to-reset-a-wordpress-password-from-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Reset a WordPress Password from phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/\",\"name\":\"Hostkicker\",\"description\":\"Blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#organization\",\"name\":\"Hostkicker\",\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/hostkicker-logo-01.png\",\"contentUrl\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/hostkicker-logo-01.png\",\"width\":940,\"height\":218,\"caption\":\"Hostkicker\"},\"image\":{\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/#\\\/schema\\\/person\\\/f06306b595baa96c90a0491b941d7660\",\"name\":\"Olivia Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g\",\"caption\":\"Olivia Smith\"},\"url\":\"https:\\\/\\\/hostkicker.com\\\/blog\\\/author\\\/olivia\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Reset a WordPress Password from phpMyAdmin - Hostkicker","description":"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to Reset a WordPress Password from phpMyAdmin","og_description":"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...","og_url":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","og_site_name":"Hostkicker","article_published_time":"2022-02-24T07:08:35+00:00","article_modified_time":"2022-05-17T06:08:33+00:00","og_image":[{"width":693,"height":511,"url":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","type":"image\/png"}],"author":"Olivia Smith","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Olivia Smith","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/"},"author":{"name":"Olivia Smith","@id":"https:\/\/hostkicker.com\/blog\/#\/schema\/person\/f06306b595baa96c90a0491b941d7660"},"headline":"How to Reset a WordPress Password from phpMyAdmin","datePublished":"2022-02-24T07:08:35+00:00","dateModified":"2022-05-17T06:08:33+00:00","mainEntityOfPage":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/"},"wordCount":392,"commentCount":0,"publisher":{"@id":"https:\/\/hostkicker.com\/blog\/#organization"},"image":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","articleSection":["Wp tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","url":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","name":"How to Reset a WordPress Password from phpMyAdmin - Hostkicker","isPartOf":{"@id":"https:\/\/hostkicker.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","datePublished":"2022-02-24T07:08:35+00:00","dateModified":"2022-05-17T06:08:33+00:00","description":"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to...","breadcrumb":{"@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#primaryimage","url":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","contentUrl":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","width":693,"height":511,"caption":"To Reset WordPress Password from phpMyAdmin, log in to the cPanel dashboard & visit the Databases section. Then click the phpMyAdmin to..."},{"@type":"BreadcrumbList","@id":"https:\/\/hostkicker.com\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hostkicker.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Reset a WordPress Password from phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/hostkicker.com\/blog\/#website","url":"https:\/\/hostkicker.com\/blog\/","name":"Hostkicker","description":"Blog","publisher":{"@id":"https:\/\/hostkicker.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostkicker.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hostkicker.com\/blog\/#organization","name":"Hostkicker","url":"https:\/\/hostkicker.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostkicker.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2021\/12\/hostkicker-logo-01.png","contentUrl":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2021\/12\/hostkicker-logo-01.png","width":940,"height":218,"caption":"Hostkicker"},"image":{"@id":"https:\/\/hostkicker.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/hostkicker.com\/blog\/#\/schema\/person\/f06306b595baa96c90a0491b941d7660","name":"Olivia Smith","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/24a6b2466362238ad275f97a2f2fc49ce8d139c034114d6b9c52de1b12ebf1bd?s=96&d=mm&r=g","caption":"Olivia Smith"},"url":"https:\/\/hostkicker.com\/blog\/author\/olivia\/"}]}},"jetpack_featured_media_url":"https:\/\/hostkicker.com\/blog\/wp-content\/uploads\/2022\/02\/MicrosoftTeams-image-46.png","_links":{"self":[{"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/posts\/1389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/comments?post=1389"}],"version-history":[{"count":3,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/posts\/1389\/revisions"}],"predecessor-version":[{"id":1675,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/posts\/1389\/revisions\/1675"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/media\/1493"}],"wp:attachment":[{"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/media?parent=1389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/categories?post=1389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostkicker.com\/blog\/wp-json\/wp\/v2\/tags?post=1389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}