Have you ever found yourself locked out of your WordPress website, unable to log in because you forgot your password, or perhaps your usual password reset method isn’t working? Don’t panic! While it might seem daunting, you can regain access to your WordPress site by directly changing your password in the database using phpMyAdmin.<\/span><\/p>\n This method is particularly useful when:<\/span><\/p>\n Let’s walk through the steps.<\/span><\/p>\n Before you begin, ensure you have:<\/span><\/p>\n Follow these instructions carefully to change your WordPress password.<\/span><\/p>\n Access your web hosting control panel and locate the phpMyAdmin icon or link. Click on it to open the phpMyAdmin interface.<\/span><\/p>\n On the left-hand side of the phpMyAdmin interface, you’ll see a list of databases. Click on the database associated with your WordPress installation. If you have multiple databases, use the name you found in <\/span> Once you’ve selected your database, you’ll see a list of tables within that database. WordPress stores user information in a table typically named <\/span> In the <\/span> Once you’ve found the correct user, click on the <\/span>“Edit”<\/span><\/strong> link (it often looks like a pencil icon) in that user’s row.<\/span><\/p>\n You’ll now see the details for the selected user. Look for the field named <\/span> After setting the <\/span> Changing your WordPress password via phpMyAdmin is a powerful and effective way to regain control of your site when standard methods fail. By following these steps, you can quickly reset your access and get back to managing your WordPress content. Remember to keep your login credentials secure and use strong, unique passwords for all your online accounts!<\/span><\/p>\n","protected":false},"featured_media":0,"parent":13,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-773","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs\/773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=773"}],"version-history":[{"count":3,"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs\/773\/revisions"}],"predecessor-version":[{"id":776,"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs\/773\/revisions\/776"}],"up":[{"embeddable":true,"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs\/13"}],"next":[{"title":"How To Use FTP ?","link":"https:\/\/www.webeyesoft.com\/blog\/docs\/others\/how-to-use-ftp\/","href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/docs\/251"}],"wp:attachment":[{"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.webeyesoft.com\/blog\/wp-json\/wp\/v2\/doc_tag?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
Prerequisites<\/span><\/h2>\n
\n
wp-config.php<\/span><\/code> file, located in the root directory of your WordPress installation. Look for the line <\/span>define('DB_NAME', 'your_database_name');<\/span><\/code>.<\/span><\/li>\n<\/ol>\nStep-by-Step Guide<\/span><\/h2>\n
Step 1: Log in to phpMyAdmin<\/span><\/h3>\n
Step 2: Select Your WordPress Database<\/span><\/h3>\n
wp-config.php<\/span><\/code> to identify the correct one.<\/span><\/p>\nStep 3: Find the <\/span>
wp_users<\/span><\/code> Table<\/span><\/h3>\nwp_users<\/span><\/code> (or <\/span>wp_<\/span><\/code> followed by a custom prefix, like <\/span>wp_abc_users<\/span><\/code>). Locate and click on this table.<\/span><\/p>\nStep 4: Identify the User to Modify<\/span><\/h3>\n
wp_users<\/span><\/code> table, you’ll see a list of all registered users on your WordPress site. Find the row corresponding to the user whose password you want to change (usually your administrator username).<\/span><\/p>\nStep 5: Change the <\/span>
user_pass<\/span><\/code> Field<\/span><\/h3>\nuser_pass<\/span><\/code>. This is where the hashed version of the user’s password is stored.<\/span><\/p>\n\n
user_pass<\/span><\/code> field, select <\/span>MD5<\/span><\/code><\/strong> from the dropdown menu. This is crucial because WordPress stores passwords as MD5 hashes for security.<\/span><\/li>\nuser_pass<\/span><\/code> field, delete the existing hashed value and <\/span>type your new password<\/span><\/strong> in plain text. For example, if your new password is <\/span>MyStrongPassword123!<\/span><\/code>, type that directly into the value field.<\/span>Important:<\/span><\/strong> Do NOT type the MD5 hash here. phpMyAdmin will apply the MD5 function to the plain text password you enter.<\/span><\/li>\n<\/ol>\nStep 6: Apply Changes<\/span><\/h3>\n
MD5<\/span><\/code> function and entering your new plain text password in the <\/span>user_pass<\/span><\/code> field, scroll down to the bottom of the page and click the <\/span>“Go”<\/span><\/strong> button to save your changes.<\/span><\/p>\nImportant Notes & Troubleshooting<\/span><\/h2>\n
\n
wp_xyz_users<\/span><\/code> instead of <\/span>wp_users<\/span><\/code>), make sure you select the correct table name.<\/span><\/li>\nConclusion<\/span><\/h2>\n