{"id":15806,"date":"2026-02-06T05:57:35","date_gmt":"2026-02-06T05:57:35","guid":{"rendered":"https:\/\/www.copebusiness.com\/?p=15806"},"modified":"2026-02-07T10:34:15","modified_gmt":"2026-02-07T10:34:15","slug":"reset-wordpress-password-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/","title":{"rendered":"How to Reset WordPress Password from phpMyAdmin (Step-by-Step Guide)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"15806\" class=\"elementor elementor-15806\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-48cd4138 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"48cd4138\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7a51137e\" data-id=\"7a51137e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64a918a1 elementor-widget elementor-widget-text-editor\" data-id=\"64a918a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\n<p class=\"wp-block-paragraph\">Forgetting your WordPress admin password is frustrating \u2014 especially if you\u2019re locked out of your site and don\u2019t have access to the registered email. The fastest and most reliable way to regain access is by resetting the password directly in the database using phpMyAdmin. This method works even when email resets fail, plugins don\u2019t load, or you\u2019ve lost access to the recovery email.<br \/><br \/>At Cope Business, we use this technique regularly during site recovery and security audits for clients as part of our <a href=\"https:\/\/www.copebusiness.com\/technical-seo-services\/technical-seo-audit-service\/\" target=\"_blank\" rel=\"noreferrer noopener\">technical SEO audit services<\/a>. It\u2019s safe when done carefully and takes only a few minutes.<br \/><br \/><strong>Important<\/strong>: This guide assumes you have access to your hosting control panel (cPanel, Plesk, DirectAdmin, etc.) and phpMyAdmin. Always back up your database first.<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">On this page<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0a0a0a;color:#0a0a0a\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0a0a0a;color:#0a0a0a\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Why_Use_phpMyAdmin_to_Reset_a_WordPress_Password\" >Why Use phpMyAdmin to Reset a WordPress Password?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Prerequisites\" >Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Step-by-Step_Reset_WordPress_Password_via_phpMyAdmin\" >Step-by-Step: Reset WordPress Password via phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Alternative_One-Click_Reset_Using_a_Plugin_If_You_Can_Still_Access_the_Dashboard\" >Alternative: One-Click Reset Using a Plugin (If You Can Still Access the Dashboard)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Best_Practices_After_Resetting\" >Best Practices After Resetting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.copebusiness.com\/fr\/wordpress\/reinitialiser-wordpress-password-phpmyadmin\/#Final_Thoughts\" >Final Thoughts<\/a><\/li><\/ul><\/nav><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Use_phpMyAdmin_to_Reset_a_WordPress_Password\"><\/span>Why Use phpMyAdmin to Reset a WordPress Password?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<ul class=\"wp-block-list\">\n<li>Works when email reset is broken or inaccessible<\/li>\n\n<li>No need for plugins or FTP access to files<\/li>\n\n<li>Instant access recovery<\/li>\n\n<li>No third-party tools or waiting for support<\/li>\n<\/ul>\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<ul class=\"wp-block-list\">\n<li>Access to your hosting account (cPanel \/ hosting dashboard)<\/li>\n\n<li>phpMyAdmin access (usually under \u201cDatabases\u201d section)<\/li>\n\n<li>Your database name and username (found in wp-config.php or hosting panel)<\/li>\n<\/ul>\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-by-Step_Reset_WordPress_Password_via_phpMyAdmin\"><\/span>Step-by-Step: Reset WordPress Password via phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<h3 class=\"wp-block-heading\">Step 1: Log in to phpMyAdmin<\/h3>\n\n<ol class=\"wp-block-list\">\n<li>Log in to your hosting control panel (cPanel, etc.).<\/li>\n\n<li>Find and open <strong>phpMyAdmin<\/strong>.<\/li>\n\n<li>On the left sidebar, select your WordPress database (usually named something like yourname_wp123).<\/li>\n<\/ol>\n\n<h3 class=\"wp-block-heading\">Step 2: Find the wp_users Table<\/h3>\n\n<ol class=\"wp-block-list\">\n<li>In the left sidebar, locate and click the table named wp_users (or whatever your prefix is \u2014 e.g., cope_users if you changed the prefix).<\/li>\n\n<li>Click the <strong>Browse<\/strong> tab to see all users.<\/li>\n<\/ol>\n\n<h3 class=\"wp-block-heading\">Step 3: Locate Your Admin User<\/h3>\n\n<ol class=\"wp-block-list\">\n<li>Look for your username in the user_login column.<\/li>\n\n<li>Or find your email in the user_email column.<\/li>\n\n<li>Click <strong>Edit<\/strong> (pencil icon) on that row.<\/li>\n<\/ol>\n\n<h3 class=\"wp-block-heading\">Step 4: Reset the Password<\/h3>\n\n<ol class=\"wp-block-list\">\n<li>In the edit view, find the row where Field = user_pass.<\/li>\n\n<li>In the <strong>Function<\/strong> dropdown next to it, select <strong>MD5<\/strong>.<\/li>\n\n<li>In the <strong>Value<\/strong> field, type your new password (plain text).\n<ul class=\"wp-block-list\">\n<li>Example: If you want the password to be NewPass123!, type exactly that.<\/li>\n<\/ul>\n<\/li>\n\n<li>Leave all other fields unchanged.<\/li>\n\n<li>Scroll down and click <strong>Go<\/strong> (or <strong>Save<\/strong>) at the bottom.<\/li>\n<\/ol>\n\n<p class=\"wp-block-paragraph\">WordPress will automatically hash the password using MD5 \u2192 bcrypt internally.<\/p>\n\n<h3 class=\"wp-block-heading\">Step 5: Test the New Password<\/h3>\n\n<ol class=\"wp-block-list\">\n<li>Go to your login page (yoursite.com\/wp-login.php).<\/li>\n\n<li>Enter your username\/email and the new password you just set.<\/li>\n\n<li>You should now be logged in successfully.<\/li>\n<\/ol>\n\n<p class=\"wp-block-paragraph\"><strong>Important<\/strong>: Change the password again from the WordPress dashboard (Users \u2192 Your Profile \u2192 Generate Password) to use a stronger, properly hashed one.<\/p>\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Alternative_One-Click_Reset_Using_a_Plugin_If_You_Can_Still_Access_the_Dashboard\"><\/span>Alternative: One-Click Reset Using a Plugin (If You Can Still Access the Dashboard)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<p class=\"wp-block-paragraph\">If you still have partial access or another admin account:<\/p>\n\n<ol class=\"wp-block-list\">\n<li>Install <strong>Reset Password by Email<\/strong> or <strong>Login LockDown<\/strong> (temporary) \u2192 reset via email.<\/li>\n\n<li>Or install <strong>WP Reset<\/strong> or <strong>Emergency Reset Password<\/strong> (use carefully \u2014 only on staging).<\/li>\n<\/ol>\n\n<p class=\"wp-block-paragraph\">But phpMyAdmin is the most reliable when locked out completely.<\/p>\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Best_Practices_After_Resetting\"><\/span>Best Practices After Resetting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<ul class=\"wp-block-list\">\n<li><strong>Immediately change password again<\/strong> from inside WordPress (uses stronger hashing).<\/li>\n\n<li><strong>Enable 2FA<\/strong> (use Two Factor or Wordfence 2FA).<\/li>\n\n<li><strong>Limit login attempts<\/strong> (see our <a href=\"https:\/\/www.copebusiness.com\/security\/limit-login-attempts-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">guide<\/a>).<\/li>\n\n<li><strong>Use strong, unique passwords<\/strong> (password manager recommended).<\/li>\n\n<li><strong>Change database prefix<\/strong> if not already done (adds extra security layer).<\/li>\n\n<li><strong>Backup regularly<\/strong> \u2014 prevent future lockouts.<\/li>\n<\/ul>\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Final_Thoughts\"><\/span>Final Thoughts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n<p class=\"wp-block-paragraph\">Resetting a lost WordPress password via phpMyAdmin is fast, reliable, and works even when everything else fails. Always back up first and change the password again from the dashboard afterward.<\/p>\n\n<p class=\"wp-block-paragraph\">A quick recovery keeps your site running \u2014 and your SEO safe.<\/p>\n\n<p class=\"wp-block-paragraph\">Locked out or need help securing your WordPress site? <a href=\"https:\/\/www.copebusiness.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">Contact Cope Business<\/a> for a free technical SEO consultation \u2014 we\u2019ll get you back in control quickly and harden your site against future issues.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Forgetting your WordPress admin password is frustrating &mdash; especially if you&rsquo;re locked out of your site and don&rsquo;t have access [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15811,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[177],"tags":[],"class_list":["post-15806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/posts\/15806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/comments?post=15806"}],"version-history":[{"count":4,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/posts\/15806\/revisions"}],"predecessor-version":[{"id":15920,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/posts\/15806\/revisions\/15920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/media\/15811"}],"wp:attachment":[{"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/media?parent=15806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/categories?post=15806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.copebusiness.com\/fr\/wp-json\/wp\/v2\/tags?post=15806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}