{"id":6924,"date":"2019-12-17T06:09:17","date_gmt":"2019-12-17T06:09:17","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6924"},"modified":"2025-04-16T10:27:03","modified_gmt":"2025-04-16T09:27:03","slug":"how-to-reset-wordpress-password-with-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/","title":{"rendered":"How To Reset WordPress Password With phpMyAdmin?"},"content":{"rendered":"\n<p>It will be a frustrating moment, especially when you can&#8217;t use the \u201cLost your password?\u201d link due to email issues or login errors. It may look like you are locked out of your website, but don&#8217;t worry. There is a quick and secure way to gain phpMyadmin access. It is a powerful database management tool that is available in most cPanel hosting environments.&nbsp;<\/p>\n\n\n\n<p>Through phpMyAdmin, it is possible to directly change the password stored in the WordPress database without the existing process being logged in. This can be useful for developers, owners, and any other users who have access to cPanel and want to reset a password without depending on the email recovery. In this article, you will learn the steps for successfully resetting your WordPress password through phpMyAdmin.<\/p>\n\n\n\n<p><strong>Requirements:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You will need the name of your WordPress database.<\/li>\n\n\n\n<li>You will need your cPanel login credentials (username and password).<\/li>\n\n\n\n<li>To Identify the Database for your WordPress Website:<\/li>\n\n\n\n<li>Login to your cPanel account.<\/li>\n\n\n\n<li>Click File Manager on the cPanel dashboard.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1830\" height=\"845\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png\" alt=\"Click File Manager on the cPanel dashboard\" class=\"wp-image-16708\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Browse to the location of your domain folder and view the wp-config.php file.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1905\" height=\"875\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/view-the-file.png\" alt=\"view-the-file\" class=\"wp-image-16714\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You\u2019ll find the database file as shown below:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1363\" height=\"563\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/database-file.png\" alt=\"database file\" class=\"wp-image-16711\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Accessing phpMyAdmin:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1898\" height=\"920\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/accessing-phpmyadmin.png\" alt=\"Accessing phpMyAdmin\" class=\"wp-image-16712\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to \u2018database group of icons\u2019 and click on \u2018phpMyAdmin\u2019.<\/li>\n\n\n\n<li>The list of databases is displayed, select the database of your WordPress website.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1514\" height=\"600\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/select-the-database-of-your-wordpress-website.png\" alt=\"select the database of your WordPress website\" class=\"wp-image-16715\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter A New Password:<\/li>\n<\/ul>\n\n\n\n<p>Here are the steps for changing the password in the database.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the table list, click on the users table. Note that the table prefix might vary for every website. Please refer to the below screenshot to get the idea.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1569\" height=\"669\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/users-table.png\" alt=\"users table\" class=\"wp-image-16716\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the \u2018Edit\u2019 option present next to the user you want to set the password for.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1648\" height=\"504\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/set-the-password.png\" alt=\"set the password\" class=\"wp-image-16717\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the password in the Value box of the user_pass field.<\/li>\n\n\n\n<li>In the Function box present next to the password option, select MD5.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1640\" height=\"734\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/select-md5.png\" alt=\"select MD5\" class=\"wp-image-16718\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on \u2018Go\u2019.<\/li>\n\n\n\n<li>Your password has now been successfully reset.<\/li>\n<\/ul>\n\n\n\n<div class=\"vlt-box \">\n<div class=\"box-title\" style=\"background:#D5EAFF; color:#000\">Conclusion<\/div>\n<div class=\"box-content\" >\n<p>Although resetting your WordPress password in phpMyAdmin might sound somewhat difficult, you can see it is pretty simple as long as you follow the proper procedures. It allows you to bypass access to your site, which is very useful if traditional recovery options fail or to help a client regain access.<\/p>\n<p>Just be careful making edits within phpMyAdmin &#8211; you are directly manipulating your database. Always review your modifications, and only alter what is necessary. With this solution in your skill set, you are never fully locked out of your WordPress site again.<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>It will be a frustrating moment, especially when you can&#8217;t use the \u201cLost your password?\u201d link due to email issues or login errors. It may look like you are locked out of your website, but don&#8217;t worry. There is a quick and secure way to gain phpMyadmin access. It is a powerful database management tool [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[925,17],"tags":[616,1159,78,86,1160,178],"class_list":["post-6924","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-phpmyadmin","category-wordpress-faq","tag-phpmyadmin","tag-reset-password","tag-wordpress-2","tag-wordpress-blog","tag-wordpress-password","tag-wordpress-website"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Reset WordPress Password With phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Reset WordPress Password With phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-17T06:09:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-16T09:27:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1830\" \/>\n\t<meta property=\"og:image:height\" content=\"845\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ujwala\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ujwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/\",\"name\":\"How To Reset WordPress Password With phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png\",\"datePublished\":\"2019-12-17T06:09:17+00:00\",\"dateModified\":\"2025-04-16T09:27:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"description\":\"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png\",\"width\":1830,\"height\":845,\"caption\":\"Click File Manager on the cPanel dashboard\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Reset WordPress Password With phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\",\"name\":\"Ujwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"caption\":\"Ujwala\"},\"description\":\"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Reset WordPress Password With phpMyAdmin?","description":"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.","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:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How To Reset WordPress Password With phpMyAdmin?","og_description":"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-12-17T06:09:17+00:00","article_modified_time":"2025-04-16T09:27:03+00:00","og_image":[{"width":1830,"height":845,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png","type":"image\/png"}],"author":"Ujwala","twitter_misc":{"Written by":"Ujwala","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/","name":"How To Reset WordPress Password With phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png","datePublished":"2019-12-17T06:09:17+00:00","dateModified":"2025-04-16T09:27:03+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"description":"This article portrays steps for resetting the password to your WordPress account by accessing user databases through phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/12\/click-file-manager-on-the-cpanel-dashboard.png","width":1830,"height":845,"caption":"Click File Manager on the cPanel dashboard"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-reset-wordpress-password-with-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Reset WordPress Password With phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8","name":"Ujwala","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","caption":"Ujwala"},"description":"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/"}]}},"views":586,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6924"}],"version-history":[{"count":10,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6924\/revisions"}],"predecessor-version":[{"id":16719,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6924\/revisions\/16719"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}