{"id":6811,"date":"2022-07-08T12:09:22","date_gmt":"2022-07-08T06:39:22","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=6811"},"modified":"2022-07-08T12:10:35","modified_gmt":"2022-07-08T06:40:35","slug":"how-to-reset-the-wordpress-password-in-mysql","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/","title":{"rendered":"How to reset the WordPress password in Mysql"},"content":{"rendered":"\n<p>Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password.<\/p>\n\n\n\n<p>WordPress passwords can be easily changed via the \u201cLost Password\u201d WordPress login form. However, if the WordPress account has no way of accessing his email address, changing the password using this mechanism can be impossible. In such cases, the job of updating a WordPress account password can only be managed by a system administrator with full privileges to the MySQL database&nbsp;<\/p>\n\n\n\n<p><strong>Prerequisite<\/strong><\/p>\n\n\n\n<p>A system running Ubuntu 18.04\/20.04&nbsp; should have the following<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>A user account with sudo privileges<\/li><li>Mysql DB credentials<\/li><\/ol>\n\n\n\n<p><strong>Implementation<\/strong><\/p>\n\n\n\n<p><strong>Step 1: <\/strong>SSH the server<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ ssh user@ip<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Step 2: <\/strong>Login to the MySQL database with the user name and password&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ mysql -u username -p dbname<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Step 3:<\/strong> View the stored databases<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ show databases;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Step 4:<\/strong> Change the database as wptest<br><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ use wptest;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/GBMnt1KxzPYAfJCeaMwUgJyQ6mI9bw2CIp_m-goXRlaUS9vDUJM1GN8uYULusbbXUXCVcMLpcqmUM47lCBkW9K5lf2P-uL9DNBBVCHEg-seI7z_54zajiFKnD-E9ZZ8Kta3WO3sPi2b1oHCsOvI\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Step 5:<\/strong> Show the tables in the database &#8211; wptest<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ show tables;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/_2gIzvvGgoua3PtsOyMxzW5I2JKKVAeGrD55CvuShPNyTAdsyv7Wytt98-Uc9gmbiRMOoHetHsQAe87YcC0lNtJoDtO0Qr8TKrWEBs6MBBk0nszxnnrpsRc56IRgf8OYIUmM23KRaykLTZMthsM\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Step 6:<\/strong> The password for WordPress is saved in the table wp_users. Explain the fields in wp_users&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ explain wp_users;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/fVkBSdbzw2Y7p36JwhX2QaL0eNM3eZmOtolwFGSNrPV8DgiO8jGA-yZnJ3e3YVolrnLZo_8zG2jNBMaV0KnB93PxMd3ENebw7XAf-Id9wMirP80wEW0z_WC9VBhgZRzunxpuXdfA2CChCmOXcSw\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Step 7:<\/strong> The user list is saved in user_login to find the user list follow the command mentioned<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ select user_login from wp_users;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/Bv_5IXPxQQGJPAfF8MH_zcWYSIIRTO3qJMs9UBkjIaKblWh28W4veaaMv-uqMXkgssHQzX0tfkhBEHaM_F1hhD7AIPylA4ia9PdIew3qp1NWqmeNDWErACWNOjrpd35G2vg6z7QMFwohmKYmTv4\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Step 8: <\/strong>We need to update the password for the user &#8211; admin. To update the password follow the below command<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>$ update wp_uesrs set user_pass=MD5(\u2018new password\u2019) where user_login=\u2019admin\u2019;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/D422WEGNN4MQoOPDlaOkIzNAEju_THCo5svOKJajYn5RkEq3NkAxUeE6lhL9s79zx40NNJIPRZr4t5xLLCZCPwcfam-15eUpHoVXcK6-nEle6ye77C9-0MBm7M6W7D_NIGCNNjgMeapgLKLqyLE\" alt=\"\" \/><\/figure>\n\n\n\n<p>Step 9: Now the password is updated we can log in to WordPress with the updated password.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/RyOi-cMzD39CiumHoWEZUYR_cAhkpbEstI7QRlLHQ2UPAWIc3QNrZGiIpZ1-AtIKuLI_nmjPKX_Aoan6GXG20EgqZVTMqx9KiYPVPSDLf13OGnf78g9_xcReWw8XlmeSpv4MF6Fr_uuCJC_te80\" alt=\"\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can be easily changed via the \u201cLost Password\u201d WordPress login form. However, if the WordPress account has no way of accessing his email&hellip; <a href=\"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/\" class=\"more-link read-more\" rel=\"bookmark\">Continue Reading <span class=\"screen-reader-text\">How to reset the WordPress password in Mysql<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":495,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[386,387,246],"tags":[179,195,167],"class_list":{"0":"post-6811","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-database","7":"category-mysql-database","8":"category-wordpress-3rdparty","9":"tag-mysql-2","10":"tag-password","11":"tag-wordpress-2","12":"h-entry","14":"h-as-article"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pheonix Solutions - We Empower Your Business Growth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can be easily changed via the \u201cLost Password\u201d WordPress login form. However, if the WordPress account has no way of accessing his email&hellip; Continue Reading How to reset the WordPress password in Mysql\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-08T06:39:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-08T06:40:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\" \/>\n<meta name=\"author\" content=\"meenakshi k\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"meenakshi k\" \/>\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:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/\"},\"author\":{\"name\":\"meenakshi k\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d573de3a2c02cbeca49e90581a88b98f\"},\"headline\":\"How to reset the WordPress password in Mysql\",\"datePublished\":\"2022-07-08T06:39:22+00:00\",\"dateModified\":\"2022-07-08T06:40:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/\"},\"wordCount\":263,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\",\"keywords\":[\"mysql\",\"Password\",\"Wordpress\"],\"articleSection\":[\"Database\",\"Mysql\",\"Wordpress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\",\"datePublished\":\"2022-07-08T06:39:22+00:00\",\"dateModified\":\"2022-07-08T06:40:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\",\"contentUrl\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/how-to-reset-the-wordpress-password-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to reset the WordPress password in Mysql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/d573de3a2c02cbeca49e90581a88b98f\",\"name\":\"meenakshi k\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g\",\"caption\":\"meenakshi k\"},\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/meenakshi\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","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:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can be easily changed via the \u201cLost Password\u201d WordPress login form. However, if the WordPress account has no way of accessing his email&hellip; Continue Reading How to reset the WordPress password in Mysql","og_url":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2022-07-08T06:39:22+00:00","article_modified_time":"2022-07-08T06:40:35+00:00","og_image":[{"url":"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s","type":"","width":"","height":""}],"author":"meenakshi k","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"meenakshi k","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/"},"author":{"name":"meenakshi k","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/d573de3a2c02cbeca49e90581a88b98f"},"headline":"How to reset the WordPress password in Mysql","datePublished":"2022-07-08T06:39:22+00:00","dateModified":"2022-07-08T06:40:35+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/"},"wordCount":263,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s","keywords":["mysql","Password","Wordpress"],"articleSection":["Database","Mysql","Wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/","url":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#primaryimage"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s","datePublished":"2022-07-08T06:39:22+00:00","dateModified":"2022-07-08T06:40:35+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#primaryimage","url":"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s","contentUrl":"https:\/\/lh3.googleusercontent.com\/aFeQp6v4cKDnhlyP6RuBz7XKnBM_52Zy2LZt-IMg6Y34lu62oEOkYbTmoffEM21bqmqDP7tG4iCXconWh4nKE5CcJV6JR0KMZbf24FE18LK5bmUMOdriXUMNsCEbyMIp_WK8nqm2neAMfR3iQ9s"},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/how-to-reset-the-wordpress-password-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to reset the WordPress password in Mysql"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/d573de3a2c02cbeca49e90581a88b98f","name":"meenakshi k","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17c0a3923b9a31a41d8de2fdc928e514efe879fe17b6e5d2814b7f81ed2356e5?s=96&r=g","caption":"meenakshi k"},"url":"https:\/\/pheonixsolutions.com\/blog\/author\/meenakshi\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-1LR","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/495"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6811"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6811\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}