Deprecated: version_compare(): Passing null to parameter #2 ($version2) of type string is deprecated in /var/www/html/wpxss.com/application/wp-content/plugins/tweet-old-post-pro/vendor/codeinwp/themeisle-sdk/load.php on line 24

Deprecated: version_compare(): Passing null to parameter #2 ($version2) of type string is deprecated in /var/www/html/wpxss.com/application/wp-content/plugins/tweet-old-post-pro/vendor/codeinwp/themeisle-sdk/load.php on line 29

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pb-seo-friendly-images domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/html/wpxss.com/application/wp-includes/functions.php on line 6260

Deprecated: mb_convert_encoding(): Handling HTML entities via mbstring is deprecated; use htmlspecialchars, htmlentities, or mb_encode_numericentity/mb_decode_numericentity instead in /var/www/html/wpxss.com/application/wp-content/plugins/wp_glossary/includes/class-wpg-linkify.php on line 316
How to Reset WordPress Password from phpMyAdmin Database - wpXSS

Deprecated: Function wp_get_loading_attr_default is deprecated since version 6.3.0! Use wp_get_loading_optimization_attributes() instead. in /var/www/html/wpxss.com/application/wp-includes/functions.php on line 6260
Database » How to Reset WordPress Password from phpMyAdmin Database

How to Reset WordPress Password from phpMyAdmin Database


Deprecated: mb_convert_encoding(): Handling HTML entities via mbstring is deprecated; use htmlspecialchars, htmlentities, or mb_encode_numericentity/mb_decode_numericentity instead in /var/www/html/wpxss.com/application/wp-content/plugins/wp_glossary/includes/class-wpg-linkify.php on line 316

Locked out of your wp-admin area? Forgot the password? No problem, the easiest way to regain access is to reset your admin password from your database via phpMyAdmin.

Step 1. Open PHPMyAdmin

The first step is to log into your cPanel and under Databases select phpMyAdmin.

The first step is to log into your cPanel and under Databases select phpMyAdmin 1024x498 1 - How to Reset WordPress Password from phpMyAdmin Database
log into your cPanel and under Databases select phpMyAdmin

Step 2. Select your database name

From the left side click on the database used by the WordPress installation that you want to reset the password for.

select db - How to Reset WordPress Password from phpMyAdmin Database
Select your database name in PHPMyAdmin
TIP: You can find the database name inside wp-config.php file

Step 3. Open wp_users table and click on the edit button next to the user.

Once you are in the right database look for a wp_users table and then click on the Edit before your username.

locate and edit - How to Reset WordPress Password from phpMyAdmin Database
Open wp_users table and click on the edit button next to the user

Step 4. Set new password, choose MD5 and save it.

Under the user_pass row, for Function select MD5, and for Value put your new password.

Set new password choose MD5 and save it - How to Reset WordPress Password from phpMyAdmin Database
Set new password, choose MD5 and save it

Click on the Go button at the bottom of the screen and thats it, you’ve just reset your WordPress admin password via phpMyAdmin and can now login to the wp-admin.

See also  WooCommerce 📱 phone number verification (+381)

Was this post helpful?

Leave a Comment

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.

Recommended