Yesterday I installed a new WP in the GD space. After I installed it in a hurry, I left because of something. The default password specified by the system was still the default password specified by the system. Later, when I tried to log in to the backend to check, I found that I forgot to copy and save the password and did not change it. What should I do? If you search online, there is still a way.
Enter the database where WordPress is located and execute the SQL command:
“update user set password=password(“new password”) where user=”username”;”
For example: “update user set password=password("zhaorong") where user="admin";"
Or you can use the md5 encrypted value of the new password to modify it. The SQL command is:
update wp_users set user_pass='new password md5 encrypted value' where user_login='username';
For example, the md5 encrypted value corresponding to "zhaorong" is "6e42b4fc7bb759b4f0ded42492586d43", and the corresponding command is:
update wp_users set user_pass='6e42b4fc7bb759b4f0ded42492586d43' where user_login=' admin';
After executing the command in the above example, the username for logging in to our WordPress backend is admin, and the password is zhaorong.
