If you forget your wordpress account password, how to modify it through mysql database (illustration)

The content of this article is about how to modify the WordPress account password through the MySQL database if you forget it (illustration). It has certain reference value. Friends in need can refer to it. I hope it will help You helped.

The WordPress program is relatively popular and is widely used by large websites, small blogs and foreign trade. It is normal to occasionally forget passwords and accounts for various reasons; all WordPress account information exists database. Therefore, if you want to modify it, you can only search the database and then modify it in the database. (Recommended course: MySQL Tutorial)

Tools/Materials

phpmyadmin Manager

Method/Step

1. Find the website database management tool PHPmyadmin, usually in the data advanced manager provided by the virtual host.

2. Fill in the correct user name and password, log in to the database

3. Find the database that needs to be modified and click Enter the database name

4. After entering the database, click "wp_users" to enter the table field

##5. See As shown in the figure, they are the user name and user password (MD5), and the password is irreversible MD5 encryption.

##6. Change the password to "123456", then Baidu will replace its MD5 with "E10ADC3949BA59ABBE56E057F20F883E"

7. Return to the database password table, paste the converted MD5 code into the position shown in the picture, and save it automatically. The password has been modified successfully.

8. User name modification : It’s also the same as the previous step, but no conversion is required; just modify it directly.

9. In the background settings, change the password again

Notes

Please note that after modification, do not use the MD5 code to log in, but use 123456

This article ends here. For more information about the MySQL tutorial, you can follow this URL

http://www.php.cn/course/list/51.html

.

The above is the detailed content of If you forget your wordpress account password, how to modify it through mysql database (illustration). For more information, please follow other related articles on the PHP Chinese website!