{"id":129,"date":"2022-12-27T12:00:33","date_gmt":"2022-12-27T12:00:33","guid":{"rendered":"https:\/\/cyberpower.co.il\/blog\/?p=129"},"modified":"2023-01-18T16:58:11","modified_gmt":"2023-01-18T16:58:11","slug":"how-to-reset-a-wordpress-password-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","title":{"rendered":"How to Reset a WordPress Password from phpMyAdmin"},"content":{"rendered":"\n

<\/a><\/p>\n\n\n\n

Lets walk you through the easy way that you can reset your password in WordPress using phpMyAdmin. Under normal circumstances, resetting your password.
WordPress is quite easy you simply go to the logon screen and click on forgot my password. <\/p>\n\n\n\n

The problem comes if you no longer have that email address that’s in your profile.
If your WordPress website is having issues sending email then you’ll never get that email reset link.
To go around that problem you can simply go into your hosting provider’s dashboard.
We also call that the cPanel in most cases and you can reset it using the phpMyAdmin area.
Now this is a bit of an advanced technique and you’ll be using the phpMyAdmin.
Before change on your database so we suggest that you make a backup copy of your WordPress site before proceeding.
<\/p>\n\n\n\n

To Change Your Password<\/h2>\n\n\n\n

So the first thing you want to do is go ahead and log in to your WordPress hosting provider’s area it’s usually the cPanel or access the cPanel from the username and password that
you’ve got from your hosting provider.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now we’re looking for phpMyAdmin <\/strong>so we’ll just click on this and it’ll open up the databases that we have associated with our hosting provider.
You probably only have one or maybe two so, so just expand the one that you know that is associated with your website.
Once we click on that now we’ll see all the tables that are a part of our website and the table that we’re looking for is the wp_users <\/strong>table.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You might also see a different prefix ahead of users like you see here that’s for security purposes but basically you’re looking for the prefix that your hosting provider gave you underscore users so what we want to do is we want to change that so let’s click Edit here and these are all the columns that we can change for this table.
The one that we’re looking for is the one that’s associated with our username for the website. So we want to click on this one and the field that we want to change is the password field,<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The user_pass <\/strong>field and under user underscore pass you see this really interesting password and it looks like it’s very difficult and don’t worry it’s actually not the password itself that you’re seeing it’s the encrypted version of the password.
So you don’t have to create one that looks this crazy so let’s go ahead and highlight this and delete that information and then we’ll go in and you can add the value that you need for your password.
Try and make a strong password that would be difficult for someone to guess, for simplicity I’m simply going to use this and once you’re done with that we also want to click on the function <\/strong>column because we want to re-encrypt this password and we’ll be using the md5 <\/strong>encryption.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

So click on md5 <\/strong>and then down at the bottom let’s just click Go <\/strong>and the great thing about that is once we click go it will update our password.
Now you should go back and try to logged in.<\/p>\n\n\n\n

this is how to reset a WordPress password from phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"

WordPress is a name that resonates with every website creator, and the numbers speak<\/p>\n","protected":false},"author":1,"featured_media":3212,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress"],"yoast_head":"\nHow to Reset a WordPress Password from phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using 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:\/\/devclouds.io\/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=\"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using phpMyAdmin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"The Official DevClouds Blogs\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-27T12:00:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-18T16:58:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devclouds.io\/blog\/wp-content\/uploads\/2022\/12\/Reset-a-WordPress-Password.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\",\"url\":\"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\",\"name\":\"How to Reset a WordPress Password from phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\/\/devclouds.io\/blog\/#website\"},\"datePublished\":\"2022-12-27T12:00:33+00:00\",\"dateModified\":\"2023-01-18T16:58:11+00:00\",\"author\":{\"@id\":\"https:\/\/devclouds.io\/blog\/#\/schema\/person\/fdb1df0cc9ba205eaf6e8c3cbfa5bfd9\"},\"description\":\"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using phpMyAdmin\",\"breadcrumb\":{\"@id\":\"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devclouds.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Reset a WordPress Password from phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devclouds.io\/blog\/#website\",\"url\":\"https:\/\/devclouds.io\/blog\/\",\"name\":\"The Official DevClouds Blogs\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devclouds.io\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devclouds.io\/blog\/#\/schema\/person\/fdb1df0cc9ba205eaf6e8c3cbfa5bfd9\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devclouds.io\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4c13c5ef9362f7298b617e6fe5ab27e254ec14291e45ed02a9b4eb102035f60?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4c13c5ef9362f7298b617e6fe5ab27e254ec14291e45ed02a9b4eb102035f60?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"description\":\"Co-founder and CEO of Cyberpower, a multi-cloud managed application hosting platform for SMBs to save them time and money and allow them to grow their business with peace of mind and improved productivity without worrying about infra and application management hassles. He is a hands-on, execution-oriented leader and a serial entrepreneur with expertise in product, growth, tech, customer support, and customer success, particularly in the context of SaaS, Infrastructure.\",\"sameAs\":[\"https:\/\/cyberpower.co.il\/blog\"],\"url\":\"https:\/\/devclouds.io\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Reset a WordPress Password from phpMyAdmin","description":"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using 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:\/\/devclouds.io\/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":"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using phpMyAdmin","og_url":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","og_site_name":"The Official DevClouds Blogs","article_published_time":"2022-12-27T12:00:33+00:00","article_modified_time":"2023-01-18T16:58:11+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/devclouds.io\/blog\/wp-content\/uploads\/2022\/12\/Reset-a-WordPress-Password.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","url":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/","name":"How to Reset a WordPress Password from phpMyAdmin","isPartOf":{"@id":"https:\/\/devclouds.io\/blog\/#website"},"datePublished":"2022-12-27T12:00:33+00:00","dateModified":"2023-01-18T16:58:11+00:00","author":{"@id":"https:\/\/devclouds.io\/blog\/#\/schema\/person\/fdb1df0cc9ba205eaf6e8c3cbfa5bfd9"},"description":"Reset a WordPress password using phpMyAdmin. Step-by-step instructions for updating a user's password in the database using phpMyAdmin","breadcrumb":{"@id":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devclouds.io\/blog\/how-to-reset-a-wordpress-password-from-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devclouds.io\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Reset a WordPress Password from phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/devclouds.io\/blog\/#website","url":"https:\/\/devclouds.io\/blog\/","name":"The Official DevClouds Blogs","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devclouds.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devclouds.io\/blog\/#\/schema\/person\/fdb1df0cc9ba205eaf6e8c3cbfa5bfd9","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devclouds.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4c13c5ef9362f7298b617e6fe5ab27e254ec14291e45ed02a9b4eb102035f60?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4c13c5ef9362f7298b617e6fe5ab27e254ec14291e45ed02a9b4eb102035f60?s=96&d=mm&r=g","caption":"admin"},"description":"Co-founder and CEO of Cyberpower, a multi-cloud managed application hosting platform for SMBs to save them time and money and allow them to grow their business with peace of mind and improved productivity without worrying about infra and application management hassles. He is a hands-on, execution-oriented leader and a serial entrepreneur with expertise in product, growth, tech, customer support, and customer success, particularly in the context of SaaS, Infrastructure.","sameAs":["https:\/\/cyberpower.co.il\/blog"],"url":"https:\/\/devclouds.io\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/posts\/129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/comments?post=129"}],"version-history":[{"count":22,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/posts\/129\/revisions"}],"predecessor-version":[{"id":1607,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/posts\/129\/revisions\/1607"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/media\/3212"}],"wp:attachment":[{"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/media?parent=129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/categories?post=129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devclouds.io\/blog\/wp-json\/wp\/v2\/tags?post=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}