e-smartsolution ยป November 27, 2018

Daily Archives: November 27, 2018

Website developer Wordpress

How to reset password in WordPress via phpMyadmin

Published by:

How to reset password in WordPress via phpMyadmin

You can recover password in WordPress by e-mail. Now click on Lost your password? Type your username or email address and then click on Get New Password.
In the case if you also forgot your email, basically you don’t no information, us last resource to recover your user and password is by accessing the database.

1- Go to PHPMyAdmin.

You will need to access your PHPMyadmin con control panel, and go Now select table prefix_users, usually wp_users

2- Once on phpMyadmin, you can find out your email linked to your account.

You can go back the login page on wordpress to recover your password using this email linked to the username.

3- Reset the password directly on the database, mysql.

You prefer to reset the password directly on the database, to do so, you will need to encrypt your password using the MD5 encryption that is used by WordPress.

Click on the https://e-smartsolution.co.uk/encrypt/ and enter your password en click encrypt. Copy the encrypt password en paste on column that says, “users_pass” on phpMyadmin.