{"id":4158,"date":"2019-10-08T05:22:05","date_gmt":"2019-10-08T05:22:05","guid":{"rendered":"https:\/\/www.webdesigncity.com.au\/?p=4158"},"modified":"2019-11-22T12:03:31","modified_gmt":"2019-11-22T12:03:31","slug":"how-to-change-wordpress-password-from-database","status":"publish","type":"post","link":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/","title":{"rendered":"How to change WordPress password from database"},"content":{"rendered":"<p>Most of the times, you may lose your password and username of your WordPress account.<\/p>\n<p>What with so much information to process, it is a common thing that may happen to anyone.<\/p>\n<p>If you don&#8217;t have the username and password, there is no way you can access your WordPress website.<\/p>\n<p>In that case, you can easily recover the username and password using your email. But, the real problem is when you cannot access your email account.<\/p>\n<p>You may not have access to your email account because of a forgotten password or many other reasons. What do you do then? Here is an easy way to get your hands on your WordPress username and password.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4160 size-full\" title=\"change WordPress password\" src=\"https:\/\/www.webdesigncity.com.au\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\" alt=\"change WordPress password\" width=\"800\" height=\"500\" \/><\/p>\n<h2>Easy Recovery of WordPress Username and Password<\/h2>\n<p>In order to recover the password and username, you must access your database management tool.<\/p>\n<p>Most of the hosting companies suggest to <a href=\"https:\/\/wordpress.org\/support\/article\/phpmyadmin\/\" target=\"_blank\" rel=\"noopener noreferrer\">use phpMyAdmin for WordPress<\/a>. With this information, let us follow the steps given below.<\/p>\n<ul>\n<li>Access your cPanel and scroll down to the database section. There, click on the Database management tool, phpMyAdmin.\u00a0 Please note that before you make any changes in the database management tool, we suggest you to take a backup of all the MySQL databases. In case you replace something, you will always have a backup. So, download the database to your computer.<\/li>\n<li>Once you are in the database management tool, phpMyAdmin, for instance, you can view a list of all the database you have connecting to your WordPress account. Firstly, expand the table with a click.<\/li>\n<li>You will find all the usernames of each database under the table head, wp_users. This is a default table name. Click on the table name and you will find all the usernames listed on the right hand side. In addition, you will find login, user emails, user passwords, and user nicknames.<\/li>\n<li>You will find the password under the table name user_pass. When you look at it, you will be baffled by the long numerical and alphabetical password. But, don&#8217;t be confused. The alphanumeric password is to protect you. However, it is difficult to do WordPress password decrypt work. So, you can either note it down or simply change the password to something of your choice.<\/li>\n<li>Since you do not have access to your email address, you can choose to edit the email address from the table in phpMyAdmin.<\/li>\n<li>To change WordPress password, go to the user_pass row, and hit the MD5 in the drop-down menu. Now, add the new password of your choice in the Value Box. Hit Go and your password for WordPress admin is successfully updated.<\/li>\n<\/ul>\n<p>Now, using your noted database username and the new password, you can log into your WordPress admin page and manage your website.<\/p>\n<p>WordPress used MD5 hash in the older variant to encrypt passwords. It has began using better encryption techniques since WordPress 2.5.<\/p>\n<p>However, to provide backward compatibility, WordPress still acknowledges MD5.<\/p>\n<p>As quickly as you login using a password string stored as a MD5 hash, WordPress will recognize it and change it using the latest algorithms for encryption.<\/p>\n<p>Hence with the new updates in wordpress it becomes much easier to change , secure and find your passwords from the wordpress database.<\/p>\n<p><strong>Conclusion<\/strong><br \/>\nWe hope you found this article interesting and informative. In case you ever <a href=\"https:\/\/wordpress.org\/support\/topic\/forgot-admin-username-and-password\/\" target=\"_blank\" rel=\"noopener noreferrer\">forget or misplace your WordPress admin username and password<\/a>, you can simply change it using your database management. You can always access the database management tool from your cPanel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most of the times, you may lose your password and username of your WordPress account. What with so much information to process, it is a common thing that may happen to anyone. If you don&#8217;t have the username and password, there is no way you can access your WordPress website. In that case, you can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4160,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[103],"tags":[],"class_list":["post-4158","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-design"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to change WordPress password from database - Web Design City<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to change WordPress password from database - Web Design City\" \/>\n<meta property=\"og:description\" content=\"Most of the times, you may lose your password and username of your WordPress account. What with so much information to process, it is a common thing that may happen to anyone. If you don&#8217;t have the username and password, there is no way you can access your WordPress website. In that case, you can [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Design City\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webdesigncity.com.au\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-08T05:22:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-22T12:03:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1042\" \/>\n\t<meta property=\"og:image:height\" content=\"665\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sarah Smith\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@citywebdesign\" \/>\n<meta name=\"twitter:site\" content=\"@citywebdesign\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah 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\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\"},\"author\":{\"name\":\"Sarah Smith\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/f6b095c389fcb12d8d82bb54668b1539\"},\"headline\":\"How to change WordPress password from database\",\"datePublished\":\"2019-10-08T05:22:05+00:00\",\"dateModified\":\"2019-11-22T12:03:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\"},\"wordCount\":585,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#organization\"},\"image\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\",\"articleSection\":[\"Website Design\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\",\"url\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\",\"name\":\"How to change WordPress password from database - Web Design City\",\"isPartOf\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\",\"datePublished\":\"2019-10-08T05:22:05+00:00\",\"dateModified\":\"2019-11-22T12:03:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage\",\"url\":\"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\",\"contentUrl\":\"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg\",\"width\":1042,\"height\":665},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webonlinecity.com\/webdesigncityold\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to change WordPress password from database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#website\",\"url\":\"https:\/\/webonlinecity.com\/webdesigncityold\/\",\"name\":\"Web Design City\",\"description\":\"Website Design Sydney\",\"publisher\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webonlinecity.com\/webdesigncityold\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#organization\",\"name\":\"Web Design City\",\"url\":\"https:\/\/webonlinecity.com\/webdesigncityold\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webdesigncity.com.au\/wp-content\/uploads\/2019\/11\/wdc-1.png\",\"contentUrl\":\"https:\/\/www.webdesigncity.com.au\/wp-content\/uploads\/2019\/11\/wdc-1.png\",\"width\":253,\"height\":53,\"caption\":\"Web Design City\"},\"image\":{\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webdesigncity.com.au\",\"https:\/\/x.com\/citywebdesign\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/f6b095c389fcb12d8d82bb54668b1539\",\"name\":\"Sarah Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/79f54ce289126ea1f61635d648bf8217?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/79f54ce289126ea1f61635d648bf8217?s=96&d=mm&r=g\",\"caption\":\"Sarah Smith\"},\"description\":\"Sarah Smith has more then 6+ years of experience in the field of promoting brands and developing new strategies of maximizing results for businesses worldwide. With the help of expert brand development strategies suggested by Sarah, you can make your business more visible among your potential customers.\",\"sameAs\":[\"http:\/\/www.webdesigncity.com.au\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to change WordPress password from database - Web Design City","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"How to change WordPress password from database - Web Design City","og_description":"Most of the times, you may lose your password and username of your WordPress account. What with so much information to process, it is a common thing that may happen to anyone. If you don&#8217;t have the username and password, there is no way you can access your WordPress website. In that case, you can [&hellip;]","og_url":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/","og_site_name":"Web Design City","article_publisher":"https:\/\/www.facebook.com\/webdesigncity.com.au","article_published_time":"2019-10-08T05:22:05+00:00","article_modified_time":"2019-11-22T12:03:31+00:00","og_image":[{"width":1042,"height":665,"url":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg","type":"image\/jpeg"}],"author":"Sarah Smith","twitter_card":"summary_large_image","twitter_creator":"@citywebdesign","twitter_site":"@citywebdesign","twitter_misc":{"Written by":"Sarah Smith","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#article","isPartOf":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/"},"author":{"name":"Sarah Smith","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/f6b095c389fcb12d8d82bb54668b1539"},"headline":"How to change WordPress password from database","datePublished":"2019-10-08T05:22:05+00:00","dateModified":"2019-11-22T12:03:31+00:00","mainEntityOfPage":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/"},"wordCount":585,"commentCount":0,"publisher":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#organization"},"image":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage"},"thumbnailUrl":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg","articleSection":["Website Design"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/","url":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/","name":"How to change WordPress password from database - Web Design City","isPartOf":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage"},"image":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage"},"thumbnailUrl":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg","datePublished":"2019-10-08T05:22:05+00:00","dateModified":"2019-11-22T12:03:31+00:00","breadcrumb":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#primaryimage","url":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg","contentUrl":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-content\/uploads\/2019\/10\/wordpress-design-sydney.jpg","width":1042,"height":665},{"@type":"BreadcrumbList","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/how-to-change-wordpress-password-from-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webonlinecity.com\/webdesigncityold\/"},{"@type":"ListItem","position":2,"name":"How to change WordPress password from database"}]},{"@type":"WebSite","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#website","url":"https:\/\/webonlinecity.com\/webdesigncityold\/","name":"Web Design City","description":"Website Design Sydney","publisher":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webonlinecity.com\/webdesigncityold\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#organization","name":"Web Design City","url":"https:\/\/webonlinecity.com\/webdesigncityold\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/logo\/image\/","url":"https:\/\/www.webdesigncity.com.au\/wp-content\/uploads\/2019\/11\/wdc-1.png","contentUrl":"https:\/\/www.webdesigncity.com.au\/wp-content\/uploads\/2019\/11\/wdc-1.png","width":253,"height":53,"caption":"Web Design City"},"image":{"@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webdesigncity.com.au","https:\/\/x.com\/citywebdesign"]},{"@type":"Person","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/f6b095c389fcb12d8d82bb54668b1539","name":"Sarah Smith","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webonlinecity.com\/webdesigncityold\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/79f54ce289126ea1f61635d648bf8217?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/79f54ce289126ea1f61635d648bf8217?s=96&d=mm&r=g","caption":"Sarah Smith"},"description":"Sarah Smith has more then 6+ years of experience in the field of promoting brands and developing new strategies of maximizing results for businesses worldwide. With the help of expert brand development strategies suggested by Sarah, you can make your business more visible among your potential customers.","sameAs":["http:\/\/www.webdesigncity.com.au"]}]}},"_links":{"self":[{"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/posts\/4158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/comments?post=4158"}],"version-history":[{"count":3,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/posts\/4158\/revisions"}],"predecessor-version":[{"id":4175,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/posts\/4158\/revisions\/4175"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/media\/4160"}],"wp:attachment":[{"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/media?parent=4158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/categories?post=4158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webonlinecity.com\/webdesigncityold\/wp-json\/wp\/v2\/tags?post=4158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}